Connection

Hi,

I installed SQLSERVER EXPRESS Edition.When i try to connect to sqlserver express,In the server name what we have to specify.

I know that we have to specify Systemname\SqlServer instance name.

I find sqlserver instance name

in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SSMSEE

My system name is Kal.

Now my server name:kal\SSMSEE

and i followed windows authentication.

Username:kal\Administrator.

And click on connect.

Iam getting this error.Couldnot connect to SqlServer.Server does not allow Remote connections.

How to resolve this error.

Thanks in advance

Hi,

have a look at my site under the section Screencasts on the top navbar. YOu will find the Screencast for Enabling remote connections here which will guide you through the process of enabling your SQL Server (Express) for remote connectivity.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de