I have installed SQL express and setup a database and user.
I need to test the connection is working before i give the details to the customer.
Does anyone know of a free utility for connecting to a sql express database?. so i can test the connection and that they have privileges for creating tables and loading data.
There's a utility built into windows that will test SQL connections. Here's a simple way to use it.
Create an empty file called anything.udl and double click on it. Click the Provider tab, and select "Microsoft OLE DB Provider for SQL Server". Then click the connection tab, populate your connection details, and hit the "Test Connection" button.
------------------------------------------------------------------------------------ Any and all code contained within this post comes with a 100% money back guarantee.
tkizer - I set them up as a sql user. what is the best utility to use to test the login remotely? dba - I created the file thanks. When i open the file I cannot see where to enter the ip address.
You can install sqlcmd - and test the connection remotely. It's a utility that comes with the sql server installation. From the command line it would be : sqlcmd -U myName -P myPassword -S theservername\instance
If anyone knows how to enter the server address into DBA's .udl example please do let me know. Never expected finding a GUI software/utility to create a table in sql would be so difficult :). thanks
thanks tkizer. using Management Studio Express worked.
Question 1) when the user logs in they are able to see all databases. Since they only have permission for 1 shouldnt the rest automatically be hidden?
2) Which of these 2 membership roles would you opt for in a production environment to give to users. They need to be able to create tables so my options appear to be either setting them as db_accessadmin or db_ddladmin
1) They won't have access to the other databases, but they can see the names. 2) I'd suggest db_owner actually so that they can create dbo objects. But it really depends on your requirements. We don't allow users to create objects in production, we don't even allow direct table access. Instead we only grant access through stored procedures.
Hi, I have a major university project to do over christmas using PHP. I have installed WAMP and am trying to pull back using SQL some data as a test, BUT I can't connect to the database. WAMP itself doesnt ask for a login or username so am not sure whether I have one or what it would be to put into the connection string! If anyone can help it would be apprecaited as once I have it done once I should be ok. Someone did suggest using ("localhost", "e_novative", "e_novative") but this just throws up a conenction error. ================
How to test database connection?
Posted - 05/05/2010 : 15:09:21
