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 |
|
sambrown180
Starting Member
38 Posts |
 Posted - 2009-09-23 : 07:48:40
|
| Hi,I have recently installed SQL Server 2008 on my laptop after previously using a version at Uni.However I cannot seem to actually connect to anything to initiate any queires. I dont know what needs to be in the server name section or where to go from there so any help will be much appreciated thanks.Sam |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-23 : 08:46:30
|
| The cvonnection will be local, you can search for SQL Server instances fromt he drop down box. once selected, you need to choose a user (probably best to use windows authentication for now as this should be the admin user).If you still can't connect, what error are you getting? |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-09-23 : 08:57:05
|
| Have you just installed this as a default instance onto the laptop, if that is the case then your computer name will be the name of the SQL server instance on that machine.To find out the computer name go to start - Control Panal - Click on the system icon and then select Computer Name from the tabs.Then open SQL SERVER Managment Studio, and it should open up and a pop box called connect to server - against the Server name Type in the Computer name, select Windows Authentication and press connect.If you get a security right error - do you remember the SA password which you created during the install - If so simply change the authentication drop list to SQL Server authentication and type in Username = saPassword = [What ever you typed]Hope that helps--------------------------SQL Server MCP & MCTS |
|
|
|
|
|
|
Initial Connection