SQL Server connection

[Violator]

hi

There doesn't seem to be a forum section for SQL Server so this seemed the nearest & couldn't find any related posts in the other sections....

I basically can't connect to a simple SQL DB I've created on the server locally via Visual Studio 2008 as it won't accept the user credentials. It finds the server ok though.

I also don't seem to have permissions to add users at the server level in the ASP.NET enterprise manager console, however by specifying the db I created in the connection string it still no good, even though the user is db_owner (I don't know the sa/dbo user login details to test this unfortunately).

Connection details:

Server: <MY SITE IP ADDRESS>\SQLEXPRESS (have tried just with the IP)
SQL Server authentication:
User name: <username I added>
Password: <the password>

Database name: violator_test

What am I missing or am I just having a

TIA

Vio

[MrTWS]

Is this a local connection on your own PC or through web hosting uk? I'm confused, but if you can elaborate it might help get an answer

[Violator]

Thanks for the reply. Sorry the post wasn't clearer - the SQL DB is hosted on the webhosting uk server and I'm trying to access it locally on my own PC. If its not possible for security reasons no problems but it will help in testing if I can access locally.

[scottie2212]

Originally Posted by Violator

Thanks for the reply. Sorry the post wasn't clearer - the SQL DB is hosted on the webhosting.uk server and I'm trying to access it locally on my own PC. If its not possible for security reasons no problems but it will help in testing if I can access locally.

Sounds to me like you need to add a Remote Access Host.
You will need a fixed IP address at home.

You can set a remote host through Control Panel. If you don't have CP then I can only suggest you raise a support ticket.

I hope this helps.

Scottie

[IanSmithISA]

Good morning.

Although not an answer to your question, I would like to ask if you are sure that you are going about this the best way. I have a Windows VPS with SQL Server, but I do not connect to it via Dev Studio.

Instead I do all my testing on a local copy of SQL server, all changes to the database are made by running a script file that can then be run against the live server when I am ready.

I have attached a big part of a real script file, I have cropped the file after a few stored procs.

As well as being faster, as the server is local, it makes managing versions much easier.

Bye

Ian

[Violator]

Thanks for the replies. I think on reflection I will go with the local instance and test option as suggested by Ian.

[cherylfoster]

SQL is often referred to as Structured Query Language is the language of relational database engine designed to handle data management systems (RDBMS), and was originally based on relational algebra and calculus. E 'within the scope of information to add, query, update and remove the creation and modification of the scheme, and controls access to data.

[Rachael]

In order to solve any kind of SQL server problems, you can consider the flowing solutions:

1. Check that the client and server are running the same network protocol
2. If you are unable to connect with Windows authentication, make sure that the SQL server is not installed on a Windows 9x Box
3. If you get this error message – specified SQL server not found; make sure that you have specified the server name correctly and the SQL server that you have connected to is working
4. Make sure that the single user user database option is turned off
5. You must also make sure that the 'DOB use only'