Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chan_nguyen
Starting Member
4 Posts |
 Posted - 2010-07-06 : 23:13:08
|
Hello everyone,I'm a newbie to SQL Server. I followed the instruction from this video : http://technet.microsoft.com/en-us/library/dd299415(SQL.100).aspxinstalling SQL Server 2008 Developer Edition. And during the installation, I have the "Name Instance" for SQL Server is "MSSQLSERVER". I understand this is an instance or server name (correct me if I'm wrong). After all the installation, I tried to connect to the Database Engine using Microsoft SQL Server Management Studio. Since I don't set password for Windows ( I'm using Windows 7 Home Edition ), so in order to connect, I enter :Server Name: CHAN-PC\SQLEXPRESS Authentication : Windows Authentication.With this setup, everything connected fine. But, as I understand I installed a "Developer" Edition, how come I can only connect with SQLEXPRESS? And when I tried to connect using CHAN-PC\MSSQLSERVER it prompt me this error : Can anyone give me a hint that where I did wrong? Thanks a lot in advance. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-07-07 : 02:52:20
|
If you go to the Services (type "services" in the start menu search) and locate the ms sql server services. What it says in the parethesis behind the service name is your instance name: MSSQLSERVER is however the default name and it *should* work by just connecting to (local) or to CHAN-PC without any further names.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
chan_nguyen
Starting Member
4 Posts |
Posted - 2010-07-07 : 10:02:41
|
| Hi Lumbago,Thank you so much for your clear information and "fast" service ^_^ ! |
|
|
|
|
|
|
Problem connect with Database Engine