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.
| Author |
Topic |
|
ConnieXujuan
Starting Member
48 Posts |
 Posted - 2012-02-22 : 07:21:56
|
Hi -,I have just installed my SQL server 2008 express and its SSMS. However, I could not connect to my local instance. Could anyone please tell me how to connect to my local instance or create a new instance?Thanks a lot!Connie  |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-02-22 : 07:30:03
|
| Whats the error Message you get?Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
ConnieXujuan
Starting Member
48 Posts |
Posted - 2012-02-22 : 16:39:17
|
| Hi there,the erroe message says that the server is not found. I was just wondering how many ways are there to connect to a local server?Thanks a lot!Connie |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-22 : 17:19:42
|
| Do at least two things:1. Make sure that SQL server is running. You can look this up in Services.msc.2. Use the instance name as COMPUTERNAME\SQLExpress, or (local)\SqlExpress |
|
|
|
ConnieXujuan
Starting Member
48 Posts |
Posted - 2012-02-27 : 19:19:25
|
| Thanks!!! I used COMPUTERNAME\SQLExpress and now it is working!Connie |
|
|
|
|
|
|
connect to my local instance