Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RCM2007
Starting Member
5 Posts |
 Posted - 2007-08-16 : 15:56:00
|
| I have an VB 2005 .net app that runs fine under my login because I have owner status in MS SQL 7.0 security settings. Part of what the app does is create a new table, which is where is is failing with the users. They have datawriter and datareader privileges, and I've even tried giving them db_owner settings just to see if it would work, but we either get "login failed" messages from SQL or something to the effect they do not have permission to Create Tables.I felt pretty sure one of you would make short work of this issue. I'm just not a SQL administrator and table creation hasn't been in picture before now.Any suggestions would be much appreciated! |
|
|
RCM2007
Starting Member
5 Posts |
Posted - 2007-08-16 : 17:55:10
|
| I should have added that we are using Windows authentication in SQL and that all the permissions I mentioned are the ones I'm setting in Enterprise Manager. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 23:32:41
|
| How does the app connect to sql? |
|
|
|
RCM2007
Starting Member
5 Posts |
Posted - 2007-08-17 : 11:39:16
|
| Thank you for responding. The connection code is below:sConnectionString = "Data Source=DATASERVER;" & _ "Initial Catalog=THESQLDATABASE;" & _ "Integrated Security=SSPI;"dbCustom = New SqlConnection(sConnectionString)dbCustom.Open() |
|
|
|
RCM2007
Starting Member
5 Posts |
Posted - 2007-08-17 : 12:50:54
|
| Just wanted to add that I will not likely be back on the forum before Monday.I just don't want anyone who might respond to get the idea I don't respect their time enough to come back and check the post. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 01:11:32
|
| If you get login failed message, that means the windows account didn't add to sql server yet. |
|
|
|
RCM2007
Starting Member
5 Posts |
Posted - 2007-08-18 : 01:25:45
|
| I had a chance to check back one more time before leaving town.The user accounts exist in SQL Server. Please note above that I said I had tried several different settings for their SQL user accounts. These users are constant users of other aspects of this application. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 17:24:17
|
| You login windows with that account then try to connect to sql serverwith windows authentication? Still get login failed error even the login is created in sql server? I'm confused. How is it possible? |
|
|
|
|
|
|
Creating Tables from VB .NET