Wednesday, March 28, 2012

help for starting SQL Express Manager 2005

Can anyone advise how I access SQL Express Manager ?

After starting Express Manager (preview 1) and selecting "Windows Authentication" I am asked for "Server Instance" What is meant by server Instance ?
Or with "SQL Server authentication" option selected I'm asked for name and passsword as well.

Is this something I ovelooked setting up when installing SQL 2005 Express ? I dont remember setting any passwords.

WHich option should I be going for ?

Have read accompanying documentation and looked on web but have not found a guide on this.

RECEIVED THIS REPLY TO MY QUERY ON ANOTHER THREAD

Hi,

SQL Server Express default instance which is the instance that gets created when you do not specify a name is installed as SQLExpress.

In Windows Authentication the current interactive Windows User is used for logging on so you just need to supply the instance name as .\SQLExpress or
MachineName\SQLExpress.

SQL Express also supports SQL Authentication. In case you want to take that route please go through the following post:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=62998
(Scrolll down to see the thread where I have provided the steps.)

Regards,
Vikram

.\SQLExpress - worked for me for the Windows Authentication - 0oseven

No comments:

Post a Comment