| Author |
Topic |
|
Cheshire
Starting Member
12 Posts |
 Posted - 2009-01-06 : 18:57:41
|
| Hello,I've been given a rather dirty job of cleaning up an interns old PC.Part of the process is I have to configure SQL to accept user login ID from our network inventory program (Altiris).Pertinent to the SQL issues (as I understand them) are the following excerpts from the error logs:-----------------------------------SQL Server Logs are all empty.SQL activity monitor has multiple entries with DOMAIN1/USER1 associated with the eXpress database & sleeping.Altiris Data Manager;-eXpressDatabase; Error 11: General network error. Check your network documentation.-eXpressDatabase; Error 4060: Cannot open database "eXpress" requested by the login. The login failed. Login failed for user 'DOMAIN1\USER1'.Application Log;-Altiris Deployment Server; Service cannot be started. The service process could not connect to the service controller.-Altiris Deployment Server; Event ID 3; Incorrect syntax near the keyword 'and'. Statement(s) could not be prepared.-MSSQLSERVER; Event ID 17187; SQL Server is not ready to accept new client connections;-Altiris Deployment Server; Event ID 3;SQL Server does not exist or access denied. ConnectionOpen (Connect()).-mm; Event ID 3; SQL Server does not exist or access denied. ConnectionOpen (Connect()).-----------------------------------Any help, suggestions, or telling me what data / logs I should have enabled and what I should be looking for would be most appreciated.Again my thanks,-Aaron |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-06 : 19:16:52
|
| Hello tkizer,Under Microsoft SQL Server Management Studio Express;>NEWSQLSERVER (SQL Server 9.0.2047 - DOMAIN1\MYUSER)>>Security>>>Logins>>>>DOMAIN1\USER1>>>>>PropertiesUnder 'General' the user is set with a login name of 'DOMAIN1\USER1', 'Windows Authentication', default database 'master', default language 'british english'.Under 'Server roles' the user is set with 'public' and 'sysadmin'Under 'User Mapping' the user is set to 'eXpress', 'Insight_v50_0_223514856', 'VirtualManagerDB', and 'vmm_db_v2_1'. The first two have 'db_owner' checked, and all of them are checked as 'public'.There is nothing listed under 'securables'Under 'status' the user is set with 'permission to connect to database engine' Grant, 'Login' Enabled.Is there anything else I should have set to ensure this user can access the eXpress database? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-06 : 19:20:41
|
| Is eXpress database accessible by any other users? It sounds like it may be corrupt or unavailable. By the way, the user is sysadmin which means it is god on the database server. It doesn't need any other permissions as it gets everything through sysadmin. This is risky though. Only DBAs should have sysadmin. All other accounts should have only what is needed. But I digress...Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 11:35:58
|
| That I know of, no other user accounts can access the eXpress database.If I go through Start>Administrative Tools>Data Sources (ODBC)>System DSN>Altiris eXpress database>Configure>Finish>Test Data Sources It replies with 'Tested Successfully'.Which makes me think that puts network issues out of the way concerning any network problems?And setting user to SA is just so that I know it has as much permissions as possible until I get the system working, then I'll step it down to something reasonable and hope it doesn't break anything. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 12:39:18
|
| Sorry, I have no idea how I would run a query on the database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 13:02:53
|
| I do have SQL Server Management Studio Express.How would I specifically test the query using just the SA account?( or whichever account I set up with the equivalent permissions) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 14:11:35
|
| As SA>NEWSQLSERVER (SQL Server 9.0.2047 - sa)>>Databases>>>Tables>>>>dbo.bw_drive>>>>>Columns>>>>>>bw_prop_IDThen I can right click, 'modify' and see the data / settings in the file. I prsume that's what we're testing?I can then log in with the other configured local account as well. |
|
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 14:12:02
|
quote:
Originally posted by Cheshire
As SA>NEWSQLSERVER (SQL Server 9.0.2047 - sa)>>Databases>>>Tables>>>>dbo.bw_drive>>>>>Columns>>>>>>bw_prop_IDThen I can right click, 'modify' and see the data / settings in the file. I prsume that's what we're testing?I can then log in (and edit)with the other configured local account as well.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 17:41:35
|
| Quite interesting, All intended accounts, whether SQL or Windows Authenticated can access and edit the database directly.During install it requests:"The following Administrator account must exist on the Depoloyment Share and the Deployment Server. If using Active Directory, enter 'domain\user name'.So if I enter DOMAIN1\USER1 and the account password, it (should?) work?Because I've already verified the connection to the sql server using the ODBC, this issue is then strickly a matter of the installation program & how it tries to interact with the SQL server, or it's an issue with how we have active directory configured? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Cheshire
Starting Member
12 Posts |
Posted - 2009-01-07 : 18:02:26
|
| Alright thank you regardless,I know a little bit more about SQL now, And I'm comfortable saying that SQL is not the issue,So I can redivert my attention elsewhere in resolving this.-Aaron |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL configuration not acception login IDs