CODEWITHSUNDEEP
sqlsql-server-expressssms
codeAddicted
codeAddicted

Reputation: 31

Can't connect to SQL Server local database and can't find the SQL Server browser

My problem is that after I installed SQL Server Management Studio and use .\SQLEXPRESS as a server name. It says that it can't connect it.

I read lots of things about that problem and one thing was to go to computer management and check the sql server browser if it is started.

When I go there I do not find any files for sql. On time of the installing I do everything correct as it is supposed to be. That's why I cannot understand why it doesn't work. Any ideas ?

Upvotes: 1

Views: 9992

Answers (2)

joehanna
joehanna

Reputation: 1489

I suspect that you have installed the tools only (SQL Management Studio) and not SQL Server itself. If you want to connect to your own SQL Server (any instance starting with a dot ".") then you will need to install it on your machine.

You can download the full installation SQL Express package direct from Microsoft. There are several editions available to suit your environment and needs.

http://www.microsoft.com/en-au/server-cloud/products/sql-server-editions/sql-server-express.aspx

It gets a little complicated trying to find what you want since there are so many variants and editions. I recommend that you head over to Scott Hanselman's blog where he has laid it all out very nicely by release version, edition and environment (32/64 bit)

His preferred link: http://downloadsqlserverexpress.com

Original post: http://www.hanselman.com/blog/DownloadSQLServerExpress.aspx

Upvotes: 3

user1433049
user1433049

Reputation:

So, it seems it isnt installed... was it installed? Check google what it's folders are for your system and go look if the folders exist. Make a backup of existing folders and re-install if need be. then attach any existing files to to recreate the databases, if any.

Upvotes: 0

Related Questions