Monday, March 19, 2012

Connection Issue

I am a novice and have SQL 2k5 installed on my server running windows SBS 2003. I am able to connect to the database from my workstation and I am able to view all the fields of the database but I am not able to view any of the records contained in the database. Can someone please guide me. I need to be able to view add and delete records using Access as a front end program to SQL. Thank you.

How are you connecting to the server? What 'client tool' are you using? (Visual Studio, SSMS, QA, etc.)

|||I am connecting to the server via an intranet enviroment and I am logged on with administrator properties.|||

The most important thing to note is how you are connecting, like windows Authentication or with a SQL username and password.

If you can connect to the SQL Server and see some of the fields, and schema, then depending on the way you are connecting it could be that the user does not have access to SELECT from the tables.

If you are using Access to connect, you should be able to do what you want to do if you are using the appropriate permissions inside SQL for your tables.

Ben Miller

|||

Thank you!

I reset all the ODBC connections and I was able to view the data. Your response was very helpful. Thank you once more.

No comments:

Post a Comment