|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Need help connecting to SQL Server using Windows accountHi,
I want to use Windows authentication to connect to SQL Server 2005 from Access 2003 projects. I have two users in the company who need to access our SQL Server 2005 from an Access 2003 front end. I'm one of them but because I'm an admin I don't have any problem accessing the server. I don't want to create individual accounts in SQL Server so I went ahead and created a security group in the Active Directory. Then I added this security group to SQL Server logins. However, when I put users in that group in the AD, they can't connect to SQL Server. What am I doing wrong? -- Thanks, Sam try this link
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html Show quote "Sam" wrote: > Hi, > > I want to use Windows authentication to connect to SQL Server 2005 from > Access 2003 projects. I have two users in the company who need to access our > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > I'm an admin I don't have any problem accessing the server. > > I don't want to create individual accounts in SQL Server so I went ahead and > created a security group in the Active Directory. Then I added this security > group to SQL Server logins. > > However, when I put users in that group in the AD, they can't connect to SQL > Server. What am I doing wrong? > > -- > Thanks, > > Sam Not much help there. It's just advocating Windows authentication. I already
want to use Windows authentication. I need to know why I'm having trouble using it. -- Show quoteThanks, Sam "Omnibuzz" wrote: > try this link > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > -- > -Omnibuzz (The SQL GC) > > http://omnibuzz-sql.blogspot.com/ > > > > "Sam" wrote: > > > Hi, > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > Access 2003 projects. I have two users in the company who need to access our > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > I'm an admin I don't have any problem accessing the server. > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > created a security group in the Active Directory. Then I added this security > > group to SQL Server logins. > > > > However, when I put users in that group in the AD, they can't connect to SQL > > Server. What am I doing wrong? > > > > -- > > Thanks, > > > > Sam You need to create a login in SQL Server associated with the domain (AD)
group. Then you need to create a database user for that login in any database they need access. Then assign the required object permissions. All of the above can be done in Management Studio. HTH Vern Rabe Show quote "Sam" wrote: > Not much help there. It's just advocating Windows authentication. I already > want to use Windows authentication. I need to know why I'm having trouble > using it. > > -- > Thanks, > > Sam > > > "Omnibuzz" wrote: > > > try this link > > > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > > > -- > > -Omnibuzz (The SQL GC) > > > > http://omnibuzz-sql.blogspot.com/ > > > > > > > > "Sam" wrote: > > > > > Hi, > > > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > > Access 2003 projects. I have two users in the company who need to access our > > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > > I'm an admin I don't have any problem accessing the server. > > > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > > created a security group in the Active Directory. Then I added this security > > > group to SQL Server logins. > > > > > > However, when I put users in that group in the AD, they can't connect to SQL > > > Server. What am I doing wrong? > > > > > > -- > > > Thanks, > > > > > > Sam Vern,
I've already done all that. First created a login under security in Managment Studio. Then created a user under the security object of the specific database I want these users to access. Then under properties for that user, I gave the user dbo.owner role. Still doesn't work though. Am I skipping something? -- Show quoteThanks, Sam "Vern Rabe" wrote: > You need to create a login in SQL Server associated with the domain (AD) > group. Then you need to create a database user for that login in any database > they need access. Then assign the required object permissions. All of the > above can be done in Management Studio. > > HTH > Vern Rabe > > "Sam" wrote: > > > Not much help there. It's just advocating Windows authentication. I already > > want to use Windows authentication. I need to know why I'm having trouble > > using it. > > > > -- > > Thanks, > > > > Sam > > > > > > "Omnibuzz" wrote: > > > > > try this link > > > > > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > > > > > -- > > > -Omnibuzz (The SQL GC) > > > > > > http://omnibuzz-sql.blogspot.com/ > > > > > > > > > > > > "Sam" wrote: > > > > > > > Hi, > > > > > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > > > Access 2003 projects. I have two users in the company who need to access our > > > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > > > I'm an admin I don't have any problem accessing the server. > > > > > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > > > created a security group in the Active Directory. Then I added this security > > > > group to SQL Server logins. > > > > > > > > However, when I put users in that group in the AD, they can't connect to SQL > > > > Server. What am I doing wrong? > > > > > > > > -- > > > > Thanks, > > > > > > > > Sam What happens when they try to connect? What is the Access connection string?
Vern Rabe Show quote "Sam" wrote: > Vern, > > I've already done all that. First created a login under security in > Managment Studio. Then created a user under the security object of the > specific database I want these users to access. Then under properties for > that user, I gave the user dbo.owner role. > > Still doesn't work though. Am I skipping something? > -- > Thanks, > > Sam > > > "Vern Rabe" wrote: > > > You need to create a login in SQL Server associated with the domain (AD) > > group. Then you need to create a database user for that login in any database > > they need access. Then assign the required object permissions. All of the > > above can be done in Management Studio. > > > > HTH > > Vern Rabe > > > > "Sam" wrote: > > > > > Not much help there. It's just advocating Windows authentication. I already > > > want to use Windows authentication. I need to know why I'm having trouble > > > using it. > > > > > > -- > > > Thanks, > > > > > > Sam > > > > > > > > > "Omnibuzz" wrote: > > > > > > > try this link > > > > > > > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > > > > > > > -- > > > > -Omnibuzz (The SQL GC) > > > > > > > > http://omnibuzz-sql.blogspot.com/ > > > > > > > > > > > > > > > > "Sam" wrote: > > > > > > > > > Hi, > > > > > > > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > > > > Access 2003 projects. I have two users in the company who need to access our > > > > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > > > > I'm an admin I don't have any problem accessing the server. > > > > > > > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > > > > created a security group in the Active Directory. Then I added this security > > > > > group to SQL Server logins. > > > > > > > > > > However, when I put users in that group in the AD, they can't connect to SQL > > > > > Server. What am I doing wrong? > > > > > > > > > > -- > > > > > Thanks, > > > > > > > > > > Sam Vern,
I'm not using a connection string. I'm using MS Access 2003 front end. I create a project and tell Access to use Windows Authentication. When I try to connect to the database, the connection fails. -- Show quoteThanks, Sam "Vern Rabe" wrote: > What happens when they try to connect? What is the Access connection string? > > Vern Rabe > > "Sam" wrote: > > > Vern, > > > > I've already done all that. First created a login under security in > > Managment Studio. Then created a user under the security object of the > > specific database I want these users to access. Then under properties for > > that user, I gave the user dbo.owner role. > > > > Still doesn't work though. Am I skipping something? > > -- > > Thanks, > > > > Sam > > > > > > "Vern Rabe" wrote: > > > > > You need to create a login in SQL Server associated with the domain (AD) > > > group. Then you need to create a database user for that login in any database > > > they need access. Then assign the required object permissions. All of the > > > above can be done in Management Studio. > > > > > > HTH > > > Vern Rabe > > > > > > "Sam" wrote: > > > > > > > Not much help there. It's just advocating Windows authentication. I already > > > > want to use Windows authentication. I need to know why I'm having trouble > > > > using it. > > > > > > > > -- > > > > Thanks, > > > > > > > > Sam > > > > > > > > > > > > "Omnibuzz" wrote: > > > > > > > > > try this link > > > > > > > > > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > > > > > > > > > -- > > > > > -Omnibuzz (The SQL GC) > > > > > > > > > > http://omnibuzz-sql.blogspot.com/ > > > > > > > > > > > > > > > > > > > > "Sam" wrote: > > > > > > > > > > > Hi, > > > > > > > > > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > > > > > Access 2003 projects. I have two users in the company who need to access our > > > > > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > > > > > I'm an admin I don't have any problem accessing the server. > > > > > > > > > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > > > > > created a security group in the Active Directory. Then I added this security > > > > > > group to SQL Server logins. > > > > > > > > > > > > However, when I put users in that group in the AD, they can't connect to SQL > > > > > > Server. What am I doing wrong? > > > > > > > > > > > > -- > > > > > > Thanks, > > > > > > > > > > > > Sam What OS is Access running on? Does it fail if the user attempt to run the
Access app from the same host that you use? Run Profiler and create a trace with Audit Login Failed. Confirm that Access is sending the proper connection information. Vern Rabe Show quote "Sam" wrote: > Vern, > > I'm not using a connection string. I'm using MS Access 2003 front end. I > create a project and tell Access to use Windows Authentication. When I try to > connect to the database, the connection fails. > -- > Thanks, > > Sam > > > "Vern Rabe" wrote: > > > What happens when they try to connect? What is the Access connection string? > > > > Vern Rabe > > > > "Sam" wrote: > > > > > Vern, > > > > > > I've already done all that. First created a login under security in > > > Managment Studio. Then created a user under the security object of the > > > specific database I want these users to access. Then under properties for > > > that user, I gave the user dbo.owner role. > > > > > > Still doesn't work though. Am I skipping something? > > > -- > > > Thanks, > > > > > > Sam > > > > > > > > > "Vern Rabe" wrote: > > > > > > > You need to create a login in SQL Server associated with the domain (AD) > > > > group. Then you need to create a database user for that login in any database > > > > they need access. Then assign the required object permissions. All of the > > > > above can be done in Management Studio. > > > > > > > > HTH > > > > Vern Rabe > > > > > > > > "Sam" wrote: > > > > > > > > > Not much help there. It's just advocating Windows authentication. I already > > > > > want to use Windows authentication. I need to know why I'm having trouble > > > > > using it. > > > > > > > > > > -- > > > > > Thanks, > > > > > > > > > > Sam > > > > > > > > > > > > > > > "Omnibuzz" wrote: > > > > > > > > > > > try this link > > > > > > > > > > > > http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html > > > > > > > > > > > > -- > > > > > > -Omnibuzz (The SQL GC) > > > > > > > > > > > > http://omnibuzz-sql.blogspot.com/ > > > > > > > > > > > > > > > > > > > > > > > > "Sam" wrote: > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > I want to use Windows authentication to connect to SQL Server 2005 from > > > > > > > Access 2003 projects. I have two users in the company who need to access our > > > > > > > SQL Server 2005 from an Access 2003 front end. I'm one of them but because > > > > > > > I'm an admin I don't have any problem accessing the server. > > > > > > > > > > > > > > I don't want to create individual accounts in SQL Server so I went ahead and > > > > > > > created a security group in the Active Directory. Then I added this security > > > > > > > group to SQL Server logins. > > > > > > > > > > > > > > However, when I put users in that group in the AD, they can't connect to SQL > > > > > > > Server. What am I doing wrong? > > > > > > > > > > > > > > -- > > > > > > > Thanks, > > > > > > > > > > > > > > Sam |
|||||||||||||||||||||||
Other interesting topics