No Server Namr At Login - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

No Server Namr At Login

Author

Topic

TheLaz
Starting Member

4 Posts

Posted - 2008-10-03 : 08:41:38

hello everyone,

i recentally installed "Microsoft SQL Management Studio Express"
when i fire it up , in the screen "Connect to server" there is no
"Server Name" in the box. i tried to write "\SQLEXPRESS" and so on
but i get this msg:

TITLE: Connect to Server
------------------------------

Cannot connect to \SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)

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

------------------------------
BUTTONS:

OK
------------------------------

the link didn't help me..
i also checked the services: SQl Server(SQLExpress) and SQL Server Browser and they both run.

hope someone could help me , thanks

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-10-03 : 08:52:51

try just putting . (as in a full stop) that indicates to connect to the local server

Em

TheLaz
Starting Member

4 Posts

Posted - 2008-10-03 : 08:58:57

didn't help ".\SQLEXPRESS"
when i tried this i got:

TITLE: Connect to Server
------------------------------

Cannot connect to .\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

------------------------------
BUTTONS:

OK
------------------------------

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-10-03 : 09:02:38

no i mean just .

Em

TheLaz
Starting Member

4 Posts

Posted - 2008-10-03 : 09:09:14

didn't work , got the same err msg that i wrote in the first post.
do you think the problem could be something related with accounting , premissions?

TheLaz
Starting Member

4 Posts

Posted - 2008-10-03 : 15:21:01

OK i finally got the answer!
the problem was that i installed Sql server express 2008 (and C# Express 2008) but the Sql Server management studio express was 2005!
so i uninstalled everything and instlled the sql express but made sure it was 2005 and NOT 2008!

cheers!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources