janhoedt
asked on
SQL Exrpess 2008
Hi,
I have installed sql express 2008 but now would like to connect to it. Whatever I try, I cannot connect to the local instance (localhost), services are started.
Please advice.
J.
I have installed sql express 2008 but now would like to connect to it. Whatever I try, I cannot connect to the local instance (localhost), services are started.
Please advice.
J.
How are you trying? What do you already have..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I get the message in att. whatever account I use.
The strange thing is that I'm logged on as administrator but files I save are under the admin-user (a user I used before). I don't see an administrator-profile ... bizar.
2011-11-05-217.jpg
The strange thing is that I'm logged on as administrator but files I save are under the admin-user (a user I used before). I don't see an administrator-profile ... bizar.
2011-11-05-217.jpg
Check whether the service is running or not.
Try connnecting to (only dot) if the service is running.
Try connnecting to (only dot) if the service is running.
ASKER
Services are running as mentioned in first post.
ASKER
I just install sqlexpress (next, next finish) and try to connect via management studio?
Or are there other steps to take?
Or are there other steps to take?
The following links should help you here with your problem:-
http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
From http://www.connectionstrings.com/sql-server-2008
Server=myServerName\theIns tanceName; Database=m yDataBase; Trusted_Co nnection=T rue;
Use your servername instead of loclhost. Plus, i assume you are connecting with Windows authentication and your login has permission to connect to it.
From the management studio it would be the same thing, put the servername\sqlexpress as the database server and select windows authentication.
Server=myServerName\theIns
Use your servername instead of loclhost. Plus, i assume you are connecting with Windows authentication and your login has permission to connect to it.
From the management studio it would be the same thing, put the servername\sqlexpress as the database server and select windows authentication.
hi
when you install under the security settings did you add the currsent user
so you will be able to connect later ?
did you supply a password for the SA user ?
if answered YES then check under the Sql Server Configuration Manager and look under protocols to see if the TCP/IP protocol is enabled.
when you install under the security settings did you add the currsent user
so you will be able to connect later ?
did you supply a password for the SA user ?
if answered YES then check under the Sql Server Configuration Manager and look under protocols to see if the TCP/IP protocol is enabled.
ASKER
I had to fill in servername\sqlexpress, that did the trick!