connect to sql server express

Hi,

I cannot connect to the sql server express, and i recieve an alert which says:

TITLE: Connect to Server

Cannot connect to Sql Server (SQLEXPRESS).

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

BUTTONS:

OK

Hope you can help me....

Hi, some more details would help, like your connection string, and are you in fact trying to attach across a network, or is it on your local machine?|||

Did you check the remote settings ?

http://www.sqlserver2005.de/SharedFiles/RemoteConnection.jpg

HTH, jens Suessmeyer

http://www.sqlserver2005.de

|||

check this out.

http://blogs.msdn.com/sql_protocols/archive/2006/3/23.aspx

|||

Hi Isaac,

Did any of these suggestions resolve your issue? Let us know if you're still having trouble connecting.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

I'm having the same problem. I've tried the suggestions above but still no luck.

It looks like the SQLEXPRESS instance is running. I can even connect to it via Microsoft SQL Server Managment Studio Express. In MSSMSE I restarted the instance but it didn't change anything.

I just can't connect via Visual Studio Express. My local machine does not come up in the list of servers and neither does the db instance. I enter my machine name manually and still nothing.

I have the feeling if I create a new instance it'll work.

Any ideas?

Alex

|||

I did notice this in the logs:

2006-05-12 02:22:05.04 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

|||

Well, I did the steps on this page:

http://blogs.msdn.com/sqlexpress/archive/2006/04/20/580312.aspx

And I'm also referring to the server as

mymachine\SQLEXPRESS

which I wasn't doing before. I can now see the db's master, tempdb, etc.

Now the question: What's the easiest way to create a db without using the command line?

Thanks.

Alex

|||

drymedia wrote:

the question: What's the easiest way to create a db without using the command line?

Arrrr, Go to Microsoft SQL Server Management Studio Express, right-click on Databases, and choose New Database.

Not too hard.

Alex