JaedenRuiner
Well-known member
- Joined
- Aug 13, 2007
- Messages
- 340
- Programming Experience
- 10+
Okay,
I am not used to this much annoyance with things because well, I've never had to administer a database other than with Access, so some of the rules and such are very pesky and annoying.
First off, with the "Add New DataSource" in VB I am still confused as to why it needs a "file name" when the database may be on another computer and I'm connecting to it via TCP/IP or something, but that I will figure out at another time.
Right now I'm trying to do something very simple.
I've created a database and defined where the file is located (C:\db\mydb.mdf) and now I want to create the datasource/dataset for that database.
But I keep getting the same errors. First i needed to the the sp_configure for the user thingy which I did and thought that was the end of it, but it wasn't.
Through the Management Studio Express I added some user accounts, set up the mixed authentication mode (to allow "users" to log in via SQL Server Authentication), making the user logins part of the "Server" and then went to the "user mappings" of the user accounts and added them as public to the database I want to access with those users. one of which (my own) i flagged as db_owner to hopefully grant that user "god" privileges over the database. So I figure I'm going to need to learn what all those db_* roles actually mean but again save that for later.
When I use windows Authentication in the Add DataSource Wizard I get this error:
When I try to use SQL Server Authentication with an account listed not only as public but as db_owner for that specific database i get this error:
Now the funny thing is that I've managed to get the Server Explorer to connect to the database with both Windows and SQL Server authentication but I can't seem to get the system to add it as a "data source".
In the end I believe my issue is that I don't know how to correctly administer the Sql Server Express database server with Multiple "user accounts" or using the windows log in so that I can access a server database (not one specifically local to the system which is running my application) and do some processing with that db.
Any help (or references to some straight forward articles on the subject) would be most appreciated.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
I am not used to this much annoyance with things because well, I've never had to administer a database other than with Access, so some of the rules and such are very pesky and annoying.
First off, with the "Add New DataSource" in VB I am still confused as to why it needs a "file name" when the database may be on another computer and I'm connecting to it via TCP/IP or something, but that I will figure out at another time.
Right now I'm trying to do something very simple.
I've created a database and defined where the file is located (C:\db\mydb.mdf) and now I want to create the datasource/dataset for that database.
But I keep getting the same errors. First i needed to the the sp_configure for the user thingy which I did and thought that was the end of it, but it wasn't.
Through the Management Studio Express I added some user accounts, set up the mixed authentication mode (to allow "users" to log in via SQL Server Authentication), making the user logins part of the "Server" and then went to the "user mappings" of the user accounts and added them as public to the database I want to access with those users. one of which (my own) i flagged as db_owner to hopefully grant that user "god" privileges over the database. So I figure I'm going to need to learn what all those db_* roles actually mean but again save that for later.
When I use windows Authentication in the Add DataSource Wizard I get this error:
If I set the User Instance advanced property to false the error complains that the db is in use by another process or is on a unc share drive."User does not have permission to perform this action"
When I try to use SQL Server Authentication with an account listed not only as public but as db_owner for that specific database i get this error:
When I turn off the User Instance I get this error:Failedto generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
CREATE DATABASE permission denied in database 'master',
an attempt to attach an auto-named database for file C:\db\mydb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Now the funny thing is that I've managed to get the Server Explorer to connect to the database with both Windows and SQL Server authentication but I can't seem to get the system to add it as a "data source".
In the end I believe my issue is that I don't know how to correctly administer the Sql Server Express database server with Multiple "user accounts" or using the windows log in so that I can access a server database (not one specifically local to the system which is running my application) and do some processing with that db.
Any help (or references to some straight forward articles on the subject) would be most appreciated.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner