InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:59:54 GMT20http://www.sqlservercentral.com/Forums/Topic1403357-391-1.aspx:-PI got it going it was the prmissions.Thanks so much to allMon, 07 Jan 2013 21:20:42 GMTlonhannerhttp://www.sqlservercentral.com/Forums/Topic1403357-391-1.aspxIt would kinda help if you show us the code that doesn't work...What error does it give? If it's a permissions problem, the error is very specific.Mon, 07 Jan 2013 10:35:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1403357-391-1.aspxHi You could try using SSMS(SQL Server Management Studio) and run the below queries to get your permissions levels-select * from fn_my_permissions(NULL,'server') --gives Server Level Permsuse DBName ; GO ; select * from fn_my_permissions(NULL,'Database') --Gives Database Level Permsif you are not sure about SSMS, try running the below from you cmd-sqlcmd -SInstanceName -E -q"select * from fn_my_permissions(NULL,'server')"sqlcmd -SInstanceName -E -q"use DBName ;select * from fn_my_permissions(NULL,'Database')"Note: Replace InstanceName with name of you Instance and DBName with your Database Name.Once you get results, either try posting here or google out for required level of access.Hope that helps!-JOn windows 7 , if nothing works try "Run as Administrator".. :)Mon, 07 Jan 2013 10:26:08 GMTjayaraj.vemulahttp://www.sqlservercentral.com/Forums/Topic1403357-391-1.aspxI am a newbie just been doing this for about 3 mo's.I installed sql and all went well. During setup I set myself as sa using Windows AuAuthenticationI pupurchase vb.net book that came with a database on cd. I install the cd and it created a database. As I studied the book and followed all the examples I had no problems I could ADD/UPDATE records just fine using the examples. I have a client that has an access database. I created a new sql database using Access database tools/ sqlserver. Access created the database and all tables and data. So I wrote the database app. in vb.net. In my app. I can ADD/RETREIVE DATA OK, BUT IT WILL NOT UPDATE THE DATABASE. I have been over my code and even posted it on vb forum. Someone told me I did not have write permission in the database. I have not setup any user for the DCTS database. I tried to add a new user "myself" SQL would not allow me to add user. It said I did not have permission. I dont understand why I can ADD/UPDATE/RETREIVE DATA with the database that came with the book, and not be able to update my own database. as always thanks.Sun, 06 Jan 2013 14:27:07 GMTlonhanner