SQL Server accounts and logins

(0) Share

Report

Posted on by WaltBlanchard

480

Morning, I need to confirm something. We have two environments for SL, one for production and one for test, and they appear to be supported by two different SQL Servers. I log into the Mgmt Studio for test and I can navigate to the security folder and see all the domain accts for all the SL users, when I log into production, all I see in in the security folder is the sa acct, and myself (added by someone in network admin). The production server and application seems to be working correctly for the end users, and the data is being created in the production dbs properly. So I have a couple of questions, since I have never seen this one before. One, is it possible for SL to get domain user info and credentials for one SQL server that can be used by another, and two, is... as I suspect... SL on the production server installed incorrectly? Thanks in advance.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

WaltBlanchard 480 on at

Like (0)

Report

RE: SQL Server accounts and logins

Nevermind, I have figured it out. Convoluted admin scenarios, where I did not have the permissions to even see what domain accounts had rights to log in. Really strange, but hey, it is what it is. Thanks for those who took the time to read it.