| Author |
Topic |
|
BeamBrain
Starting Member
10 Posts |
 Posted - 2007-09-14 : 07:23:50
|
| Hi,I've just started a project where the customer has installed small business server (SBS). I understand this comes with sql server 2005 and IIS. The SBS is in a remote location and i therefore connect/interact via VPN/RDC. This all works fine and i can view the internal website etc. from my remote machine.The problem is connecting to the db. Typically i use 'sql server management studio express' for this and the customer provides me with the connection string details. However in this case i have no connection string details (only the ip address used to connect to the server via VPN and the compter ip to connect over RDC). The guy who did the install is none the wiser either as he 'just ran the installation disks'.So how do i connect ? Is there a default username and password to connect a new SQL server install or is there something else i need to consider ?Any help would be greatly appreciated. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 08:47:39
|
| Is the SQL Server Service actually running on the server?If you can connect with Terminal Service, or Remote Desktop, you could check that all is well and SQL Server is running etc. before trying to connect.You might need to make yourself a SQL UserID and Password whilst you are there ...Kristen |
 |
|
|
BeamBrain
Starting Member
10 Posts |
Posted - 2007-09-14 : 09:28:11
|
| Hi Kristen,Thanks for your prompt reply, much appreciated.Yes, the service is running on the server and seems to be up and running as you would expect.How do i create a new SQL userid/password. Normally i would run a create user script or work through the GUI but since i can't connect i'm unable to do that. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 10:00:04
|
| Terminal Services to the server.Fire up the SQL Client Tools (depending on which version of SQL Server you are running)Its probably set to Windows Authentication, if so you need to be in the Administrators group to have access.You can change SQL Server to also allow a UserID and Password. Then you can set up a Login (for the server). Give that user SysAdmin rights, then they can do anything.And THEN you should be able to connect more remotely (assuming firewall is not blocking anything etc. Try logging on locally whilst connected to the server with Terminal Services to prove that).And THEN you should be able to run your Create Database type scripts </Phew!>Kristen |
|
|
|
BeamBrain
Starting Member
10 Posts |
Posted - 2007-09-14 : 10:47:47
|
| Hmmm....thanks but seem to have fallen at the first hurdle in that i can't see any 'client tools'I am logged in as Admin and under Programmes > Microsoft SQL Server 2005 > Config tools i have...Reporting Services ConfigSQL Server ConfigSQL Server Error and Usage reportingSQL Server Surface Area configI've looked everywhere else (the machine is new so there's not much on it) and can't find anything relating to client tools ????? Do i have to run it from the command prompt or perhaps it's not installed (but i would imagine it's part of the standard install) ??? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 11:33:24
|
| Sounds like they are not installed. They should be under Programmes : MS SQL ...I presume they are normally installed by SBS, possibly after selecting a CheckBox (which was maybe overlooked?), but I don't know for sure.If only SQL Express/Lite/WhatEverItsCalledNow has been installed that normally does NOT have any client tools as part of the install.Kristen |
|
|
|
BeamBrain
Starting Member
10 Posts |
Posted - 2007-09-14 : 11:55:23
|
| OK thanks, i will get back to the person who did teh install and let you know the outcome. Thanks again for your help to date. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-14 : 22:57:48
|
| If you have sql2k5 express, need download ssms express from Microsoft and install it. |
|
|
|
BeamBrain
Starting Member
10 Posts |
Posted - 2007-09-20 : 09:33:00
|
| OK, making progress. They have now installed SQL Server Management Studio. When working on the remote machine (over the VPN/RDC) i can now connect to the server (via Windows Auth) and create a database etc. Next problem is how to access this remotely from SSMS on my machine. At this point it prompts me for the Server Name, Auth, Login and Password. What do i need to put here, do i have to create a user on the remote server ????Thanks again for all your help. |
|
|
|
|
Connecting to new sql server db