Issue on connecting sql server to my pc

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

Other SQL Server Topics (2005)

Issue on connecting sql server to my pc

Author

Topic

alfaaa764
Starting Member

3 Posts

Posted - 2012-08-22 : 10:48:25

hi ,

i am working on my project .i just need little help from sql server.i installed it and when i start it it appears " connect to server " window. whiask for server name. Plz guys tell me whats the server name i have to enter bacause i have tried all names like pc name ,comouter name....

Plz somebody tell me the solution...

mani

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-22 : 11:08:40

whats the name you gave for sql server instance?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

alfaaa764
Starting Member

3 Posts

Posted - 2012-08-22 : 11:23:13

i cannot remember that name ...

mani

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-22 : 11:33:49

Is it SQL Server express? IF so, go the command prompt , type sqlcmd –S(local)SQLEXPRESS . If you see “1>” that means that you managed to connect. By default SQL Express is installed as the service name SQLEXPRESS . To connect use (local)SQLEXPRESS

Is it local or remote? or are you trying to connect to another Edition?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-22 : 11:43:32

ok. go to machine where you installed sql server

go to start-> run-> type services.msc and enter

inside services listed look for SQL Server service. if its a named instance it will show name there otherwise it will MSSQLSERVER in which case your machine name would be servername

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources