Registered users    
MembershipMembership:
Latest New UserLatest:James Johnson
New TodayNew Today:12
New YesterdayNew Yesterday:13
User CountOverall:23319
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12890
Marina Roos12507
Eriq Neale2114
Stan Guinn1913
Michael Patrick1912
Robert Pearman1770
Nick Pieters1425
Stewart Brown616
william warren593
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Default install of SQL login help
Prev Next
You are not authorized to post a reply.

Author Messages
Mark Lalich User is Offline
United States
Member since
10/11/2007

Registered Users
Posts: 4
10/11/2007 05:02 PM  
We just ran a default install of SBS 2003 R2. What are the possible login credentials for SQL? I think SBS 2003 R2 comes with SQL 2000, is that correct? If so what login info do I use to log in? Any help is greatly appreciated!!
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12890
10/11/2007 06:35 PM  
No, it comes with SQL 2005 and there is no such thing as a default login. What are you trying to do?
Mariëtte Knap Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Mark Lalich User is Offline
United States
Member since
10/11/2007

Registered Users
Posts: 4
10/11/2007 09:56 PM  
During the initial setup of SBS wizards I don't remember ever setting up an initial login for SQL. So basically for me to get into SQL on this fresh SBS install what is the login username and password? Thanks again!
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133
10/12/2007 04:26 PM  
I don't quite understand what you meant by default install but if you managed to install SQL Server successfully, you can use Enterprise Manager (since you said it was SQL Server 2000) or Query Analyzer, use Windows Authentication and you should be able to login successfully as you automatically become a member of the sysadmin role in SQL Server
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12890
10/13/2007 05:48 PM  
On previous versions of SQL 2000 you could setup an instance with a blank password for 'sa'. Not a wise thing to do but it was possible. Is that what you mean?
Mariëtte Knap Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Default install of SQL login help


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.312502 seconds.   :   Terms Of Use   :   Privacy Statement