Odbc Errors After Joining New Domain With New User
Hi
I am new to this forum so I hope I have got the right one.
The problem I am having is I installed a new server into an office with 25 users. I joined the users to the new domain with new logins.
The server process then installed outlook 2003 onto each machine. Most machines are windows 2000
Problems arose in sage I have tied this down to the report designer and odbc.
On every machine bar 1 the report designer crashed when running a report. The problem like I said was that you cannot now connect to the odbc driver for sage and when you go into odbcad and try to look at the driver you get an error saying
The setup routines for the sage line 50 odbc driver could not be loaded due to system error 127
Then after that comes
Could not load the setup or translator library
I have looked on the net for this error and it tells you to look in the registry to make sure that the odbcinst is pointing to the correct location, I have checked this and it is. I ahve also checked the security and this seems ok aswell.
The next step was I loaded a fresh copy of windows 2000 into a new folder and tried to load the odbc driver again. This failed with the same as above.
This points to the software settings but I cannot find out where.
Iwas wondering if anyone has had the same problem and they could point me in the right direction.
View Complete Forum Thread with Replies
Related Forum Messages:
User On Trusted Domain Does Have Permission To Access Linked Server On AD Deployed In Another Domain
Hi, We have the followoing: -A "master domain" AD, a "sub domain" AD, a trust relationship between the two (sub trust master) -A sql server 2005 on a win server 2003 in "sub domain" AD -A linked server to "sub domain" AD -A linked server login using a "sub domain" admin acccount -A view to this linked server -A grant on masterDomain/Domain Users to the database -A grant on subDomain/Domain Users to the database -We want all connections done through "Windows Authentication" not "Database Authentication". Queries on the view work fine using "sub domain" user accounts. Queries on the view fail using "master domain" user accounts (including master domain admin accounts) "Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation." All connections are done through "Windows Authentication" not "Database Authentication". Can we establish cross domain connectivity with "Windows Authentication" ? Below are details of the implementation: SELECT TOP (100) PERCENT * FROM OPENQUERY(ADSI, 'SELECT displayname, givenName, sn, cn (etc...) FROM ''LDAP://OU=PEOPLE,DC=subDomain,DC=com'' WHERE objectCategory = ''Person'' AND objectClass = ''user'' ') EXEC sp_addlinkedsrvlogin @rmtsrvname ='ADSI', @useself='false', @rmtuser='subDomainAdminAccnt', @rmtpassword='sunDomainAdminAccntPassword'; In SQL Server Mngt Studio in Server Objects/Linked Servers/Providers/ ADSI properties security tab I have: "connections will: <be made using this security context> Remote login:'subDomainAdminAccnt' With password: 'subDomainAdminAccntPassword' Error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation. Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "SELECT displayname, givenName, sn, cn FROM 'LDAP://OU=PEOPLE,DC=subDomain,DC=com' WHERE objectCategory = 'Person' AND objectClass = 'user' " against OLE DB provider "ADsDSOObject" for linked server "ADSI".
View Replies !
Problems With Change Sql Permissions After Migrating Domain User/group Accounts Into Root Domain
I have a root domain and child domain. After using ADMT to migrate the domain user or group into the root domain, when I use enterprise manager to try and change the permissions allocated to that domain user/group, i get the 'Error 15401 NT user or Group not found'. This is a correct error as the user is now in the root domain, however sql (in sysxlogins) still thinks its in the child domain. Is there a simpler way, other than collecting the users permissions, deleting the user from SQL then adding back in with the correct domainusername format, then adding the permissions back? I tried renaming the 'name' in sysxlogins (not recommended) and while that worked, whenever I tried to add the migrated user to another database, the login name was missing and would not resolve. I believe it is something to do with the SID not matching. Any ideas on how to fix this ?
View Replies !
2005 Replication Outside My Domain Errors
I currently have replication (transactional) set up within my domain successfully using 2000 and 2005. I need to start replicating to a hosting center for a web app from my server out on the DMZ. I can use SSIS and SMS to connect, update data, etc. but when I try to replicate out there it gives me the following errors: 1. Tells me it needs a named instance so I give it the hosted server name : ABC123 2. Then I get the following: TITLE: Connect to Server ------------------------------ Cannot connect to ABC123. ------------------------------ ADDITIONAL INFORMATION: Failed to connect to server ABC123. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) Any help would be greatly appreciated!! TIA Tena
View Replies !
EVENT ID 18456 STATE: 16 Login Failed For User 'DOMAIN/user'. [CLIENT: &&<local Machine&&>] Every Minute In Event Log.
We recently upgraded to SQL 2005 from SQL 2000. We have most of our issues ironed out however about every 1 minute there is a message in the Application Event log and the SQL log that states: EVENT ID 18456 Login Failed for the users DOMAIN/ACCOUNT [CLIENT: <local machine>] This is a state 16 message which I thought meant that the account does not have access to the default database. The account is actually the account that the SQL services run under. Any ideas? We can't seem to figure this one out. We actually upgraded to 2005 from 2000 and had an error appear after every reboot that prevented the SQL Agent from running(This application has failed to start because GAPI32.dll was not found. Re-installing the application may fix this problem.) We did a full uninstall of SQL and reinstalled fresh and restored the databases from .bak files and that is when the EVENT ID 18546 started occuring every minute. We don't have any SQL heavy hitters here so please be detailed with any possible solutions. That you very much for any help you can provide! David
View Replies !
Connecting (ODBC) To SQL 2005 Express From Different Domain With Trust
Hi! I am trying to establish connection from different domain using ODBC driver with no luck! I am able to do it within my domain from any place, but it fails from outside. I have two-ways trust established between domains. Users are able to see and use resources both ways. When I create ODBC it doesn't matter if I use SQL or Windows NT authenctication, I am getting error: Connection Failed: SQLState: '01000' SQLServer Error: 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (getbyhostname()() ) Connectio Failed: SQLState: '08001' SQL Server Error: 11 I tried to set it with TCP Static Port or Dynamic. No difference. What should I look into? Any ideas? Any help? Thanks.
View Replies !
16 Bit Odbc Errors
We are in the process of upgrading some of our servers to SQL Server 7.0. The problem is that we have a number of 16 bit applications (Access 2.0) that we are slowly trying to rewrite but we just aren't there yet. I have a test server setup but I cannot access any of the databases with any of the 16 bit applications. I get a permissions error however, the permissions seem fine. Is there a step I am missing that will get these working until we can rewrite the rest? Thank-you in advance.
View Replies !
ODBC Errors
We have recently upsized several Access databases to SQL 7.0. I created the ODBC datasource to an Access frontend. The tables open but I get the following error when I try to update any of the tables: ODBC update on a linked table "tablename" failed. Followed by: [Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext and image data types cannot be used in the WHERE, HAVING, or ON clause except with the LIKE or IS NULL predicates [#306]. I have downloaded the latest MDAC. Any ideas?
View Replies !
SQL ODBC Errors
Hi, I've Got SQL 2005 installed on SBS2003. I'm trying to connect to it from XP using User/System/File DSN connections. The error it returns when I try to test the connection is 'SQL server could not be found or access is denied. The Error Codes are SQL Server Error: 2 and SQL server error: 17. All help is appreciated. Thanks, Rizwan
View Replies !
Odbc Errors
Hi All, I have a database using Access 2003 as a front end and SQL as a backend. I set up all permissions in SQL and linked all tables to the Access frontend. After putting the front end on the network for other users, they receive the following error: ODBC €” connection to <name> failed. (Error 3151) What do I need to do please
View Replies !
ODBC Trusted_Connection Call To SQLGetInfo Returns DBO As User Name, Not NT User
Hello, all: I am connecting to SQL Server 2000 with a trusted connection, and that is working fine. I then am issuing a SQLGetInfo call to find out the SQL_USER_NAME, which is always returning dbo instead of (my) Windows NT login name, which I expect to see. THe authentication is (apparently) confirmed by the SQL Server session monitor where it shows the right Windows NT user name logged in, over ODBC. With a standard SQL Login, untrusted, I definitely get the right user name back, not dbo. So: Login Type / user id /returned value from SQLGetInfo Windows Authentication / Windows login / dbo SQL Authentication / Windows login (UID) / UID The problem is that I am trying to confirm that the userid entered in a dialog or passed on the command line to my application matches the actual connected user name inside SQL Server.... My questions: Is there some pathology in Trusted_Connections that masks the Windows/NT login name and always returns UID 'dbo' from a call to SQLGetInfo? Is there a MSS (public) stored procedure that can robustly give back the logged in user name so I can bypass the SQLGetInfo call?
View Replies !
Run SQL As Domain User
SQL2K SP2 on Win2K Server in single native-mode domain I'm trying to change MSSQLServer and SQLServerAgent to run under a domain account instead of LocalSystem. SQL is not running on the DC. I get Error 22042:xp_SetSQLSecurity() returned error -2147023564, 'No mapping between account names and security ID's was done'. The SQL machine is part of the domain. I'm logged in as a Domain Admin. What is the problem?
View Replies !
How Do I Get A User's Domain?
I need to provide a UI to get the information to add a windows login to a SqlServer database. The CREATE LOGIN Sql statment requires the user name as "DomainNameUserName". I can get a list of users in XML using the following code: public static XmlDocument GetAllADDomainUsers(string DomainPath) { string domain; XmlDocument doc = new XmlDocument(); doc.LoadXml("<users/>"); XmlElement elem; DirectoryEntry searchRoot; ArrayList allUsers = new ArrayList(); if (DomainPath.Length == 0) { DirectoryEntry entryRoot = new DirectoryEntry("LDAP://RootDSE"); domain = entryRoot.Properties["defaultNamingContext"][0].ToString(); } else domain = DomainPath; searchRoot = new DirectoryEntry("LDAP://" + domain); DirectorySearcher search = new DirectorySearcher(searchRoot); search.Filter = "(&(objectClass=user)(objectCategory=person))"; search.PropertiesToLoad.Add("samaccountname"); search.PropertiesToLoad.Add("distinguishedname"); search.Sort.PropertyName = "samaccountname"; search.Sort.Direction = SortDirection.Ascending; SearchResult result; SearchResultCollection resultCol = search.FindAll(); if (resultCol != null) { for(int counter=0; counter < resultCol.Count; counter++) { result = resultCol[counter]; if (result.Properties.Contains("samaccountname")) { elem = doc.CreateElement("user"); doc.DocumentElement.AppendChild(elem); elem.SetAttribute("name", (String)result.Properties["samaccountname"][0]); elem.SetAttribute("distinguishedName", (String)result.Properties["distinguishedname"][0]); } } } return doc; } This works for listing the names but how do I get the NetBIOS domain name for a selected user as required by SqlServer? I have tried using TranslateName from secur32.dll. That works on some machines but for some reason on other machines, it returns a blank. Is there another way? Thanks for your help, Rob
View Replies !
Client ODBC Errors
As a SQL adminstrator any maintenance I perform including performing full database backups against the sql server with users connected to a certain database, causes the odbc connection to fail between the web server and the sql database. This causes all clients to experience an odbc failure. The only resolution is to reboot the webserver. There is ODBC driver incompatibilites that exist between the servers. Does anyone have any suggestions? I am in the process of a change control request to upgrade the ODBC on the production SQL server to 3.70.0623 the same as the web server but am not sure that this is the issue. Can there be something in the application itself that would be causing it to break and not reestablish the ODBC connection? Thanks David
View Replies !
Getting ODBC Timout Errors.
Hi Folks, I'm getting a ODBC timout error when i try to login to SQL server. After the initial error i try connecting again, and it works. Why is it giving me an error in the first place and then when i try reconnecting it'll work? Does anyone know. Could it be i need to update my ODBC drivers. This error all of a sudden just started happening.
View Replies !
Domain User Groups
Hi Im currently working on a intranet and trying to set up some security. The intranet acesses a SQL server 2000 database. I would like to know if there is a stored procedure(or other way) of returning all the domain groups that a user belongs to when passed the users NT login. I found xp_enumgroups which returns all the groups on the domain and also xp_logininfo which returns the users of a passed domain group. These are usful but i need to just pass the NT username and return all the Domain Groups. Any thoughts, ideas would be great! Cheers
View Replies !
Password For The Domain User
My SQL Server is running as a Domain user account and it asked me to enter the password for thr Domain user account when I was changing the Startup account from Local to Domain user. My QUESTION here is: Is there a way or command for me to change the password automatically on the Services account, if I change the password for the Domain User account/.
View Replies !
Changing User Domain
My SQL servers are using integrated windows nt security. Our user account is changing to a new domain. Is there an easy way to change the server logins to point to the new domain instead of removing the user and adding a new login from the new domain.
View Replies !
Domain User Account
New to SQL Server. Plan to install SQL Server 2005 standard edition on Windows 2k3. After searched a lot of places, still don't understand what exactly "domain user account" is. Could someone explain it to me? 1. Is this a OS account where SQL Server is running? 2. Or, is this an account under domain controller on other machine? Is this an account on DNS srver? How do I create it? 3. Or, is this an account in SQL Server? Where is this account located? How do I manage it? TIA.
View Replies !
Odbc Errors On Terminal Server
We connect via terminal services to an excel spreadsheet that has anODBC link to an access database using a pivot table, when we try torefresh the data within the excel spreadsheet we receive the followingerror "the microsoft jet database engine cannot find the input table orquery....."this works ok if the user connects to terminal services as theadministrator however if they connect as any other issue it won't workAnyone got any ideas?(have tried 2000 ts and 2003 ts)
View Replies !
Changing The Domain User Password
Is there an automatic way of changing the Domain user password getting used for running the SQL Server as a Domain user account? I'm taking about EM---Security----Domain User name and the password getting used for running the SQL Server?
View Replies !
Permissions For Domain User Account
Hi, I want to use a domain user account not belonging to local admin or domain admin groups in SQL 2000/2005 Enterprise edition. This is what I've done so far.. On the machine that is the Domain Controller: - installed SQL 2005 as a domain admin - created a domain user account using Active Directory Users and Computers. This user is only "Member of" domain users; not any Administrators group. - added this user to SQL Server Management Studio->Logins and in Server Roles assigned sysadmin role. Question 1: Do I need to give any additional permissions to this user to work with SQL? Question 2: How can I test this user for basic SQL operations like database creation? Can I use Osql? Question 3: Can I use this user account to login to my domain controller using remote desktop? I tried adding this user to remote users, but in vain. Thanks!
View Replies !
Domain - User Data Types
Hi, I'm new in MS SQL Server; comming from Firebird and PostgreSQL. I'm trying to import the SQL Script of a database I have in PostgreSQL 8; one basic SQL functionality is the "domain", as the way to create a user datatype; in my database I have one basic domain: OID: CREATE DOMAIN dom_oid AS numeric(18,0) DEFAULT nextval('oid_secuence'); Is there a similar way to create this kind of types in SQL Server? Thank you, Guillermo
View Replies !
Domain User Access Check
How to find out whether a domain user has access to sql server or not? Many domain groups have access to my sql server. I need to check whether a user has access to server or not. Probably I need to check which windows group the user belongs. This looks more like an o/s question than DB. How do you guys manage this scenario? ------------------------ I think, therefore I am - Rene Descartes
View Replies !
SQL Server 2005 Communcations Errors Through ODBC
I am the DBA for a product development company with an application currently connected to and running fine on SQL Server 2000. I have recently installed our product on 2005 sql server with compatability version of 90 and some folks have begun testing. Apparently, there are a lot of strange things happening and ODBC errors are frequent. The more they move around in the app, the more errors appear. Sometimes, they appear, sometimes they don't. The most common occurence is an error such as, x table is missing the following columns. Then the user does it again and does not receive the error. Another issues is "Application Terminating Due to Severe Database Error" and when we look at the logs our app generates: 08/10/2006 08:57:09 (01000/10054), [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). SQLColAttributes 08/10/2006 08:57:09 Table x.TS_X is missing the following columns: The user has database role membership db_data_read and db_data_write access to the database. MDAC version - 2.81.1117 ODBC version - 2000.85.1117 Could this be a permissions issue or possibly more of an ODBC issue? Any thoughts would be greatly appreciated Thanks
View Replies !
Login Failed For User &<DOMAIN&>&<MACHINE&>$'
Folks, I have read the posts concerning login failures for the ASPNET user. I have a slightly different problem, as you can see from the title of this post. My environment is a private domain that has two machines: 1) Windows 2000 server on which SQL Server is running. Let's call it FOO_SERVER. 2) Windows XP Professional on which I am running my IIS and .NET development environment. Let's call it FOO_WORK. 3) Let's call the domain, FOO_DOMAIN. The user, ASPNET, is not a domain user, but a local user, so I do not know how to establish it as a valid login for SQL Server. But this is beside the point, anyway, as the error I am getting has nothing to do with the ASPNET user. It appears that a different username is being used to access SQL Server. My connection string is: "server=FOO_SERVER;database=pubs;Trusted_Connection=yes" The error I receive is: "Login failed for user FOO_DOMAINFOO_WORK$" I am using the default settings in machine.config. Specifically <processModel> userName="machine" password="AutoGenerate" </processModel> Thanks in advance for any suggestions. -Joel
View Replies !
ASPNET User With Network Resources Elsewhere On A Domain
I've been trying to workout how, without impersonation, I can allow an application running under the default ASPNET user to access a network resource (SQL Server/ADAM) not on the same physical machine. It seems that because the ASPNET user is a local user not a domain user I can't setup windows authentication on the network resource. That seems to leave impersonation which MS et al say is unwise. Have I mised something here? Regards, Steve.
View Replies !
Domain User Or Local System Account ?
Hello,My server is part of a W2K domain. What do you advice me as account torun my SQL*Server, service started with a domain user account or aslocal system ?I need advices from a security point of view.Thank's in advance
View Replies !
Setting Up Merge Replication Without Domain User
Hi, I am trying to set up Web Synchronization using Merge Replication. The Distributor and Publisher are on the same machine. Subscriber is a windows mobile application which syncs the data using web synchronization. I have configured IIS on web server for the sync. However there is no domain user on database and web server. Is it possible set up web sync without a domain user? Which user can I then use to give permissions on the snapshot share folder. Any help is appreciated. Thanks
View Replies !
Login Failed For User '&&<DOMAIN&&>&&<COMPUTER&&>$'
In an attempt to improve security for our web server/db server setup, we have a SQL Server 2005 server set for Windows authentication only and a web server (both behind a firewall together on a single local domain). The web server is using IIS7, and the default NetworkService account to run the ASP.NET processes. I've given the NT AUTHORITYNETWORK SERVICE account access to the database in question. The SQL authentication fails, but the account failing is NOT the NetworkService account, but the <DOMAIN><COMPUTER>$ account. Note that if I use identity impersonation with a specific domain account, I can get the app to work. However, I do NOT want to use impersonation, I want the default NetworkService account to work. Does anyone know why IIS, which is supposed to be using NetworkService, is instead using the <DOMAIN><COMPUTER>$ account to connect to SQL, which is then failing? JK
View Replies !
Problem In Report Viewing By User Not From Domain
I m facing problem in order to publish my reports on the web. the anonymous person will not be able to see my reports, I do not why might be Reporting service restriction for anonymous person. My reports can only see by the person who are my domain user. I want to publish these reports to web. Can you please help me and tell me how to permit anonymous person to view my reports on the web out side domain Many thanks
View Replies !
Domain User Settings / Report Permissions
HI everybody! i got a question, maybe i oversee something here: ennvironment: sql2005, AD(2003), Citris Presentation server 4.5 if i set the permission in SQL Management studio correct, the permissision are not really corect in a citrix seesion. eg goal is to have a domain user only executing / viewing reports. to do so i went into the studio and set the permission appropriate ly to the destinated folder and the reports sitting within that folder. as a result, the domain user in his citrix session can /t run the report, but fool arounf in the settings, even could delete the report....whats wrong here? any pointers are really appreciated.... thx in advance
View Replies !
Domain Change (User Logins Broken)
Is there a way to change a logins based on domain users, we just changed domains so all the domainlogin logins are not working anymore. Do I have to reapply every security on every database object? There has to be a fix for this, its a common thing. Any help is greatly appreciated, everything i googled applied to SQL Server 2000 and system tables that dont exist in 2005
View Replies !
Help! About Login Failed For User '&<domain&>guest'
guys,,kindly help me please. PC name: WINDOWS-XP Laptop name: MACMOYLAPTOP both have sql server management studio express. when connecting FROM LAPTOP (MACMOYLAPTOP) using sql server management studio express(SSMSE), the error is always "Login Failed for user 'WINDOWS-XPGuest'" then in my PC(WINDOWS-XP), i created a login account in SSMSE named WINDOWS-XPGuest. I tried to connect again "FROM THE LAPTOP(MACMOYLAPTOP)" THE CONNECTION WAS SUCCESSFUL!! BUT!!! what will happen when another computer will try to connect?? will it be logging in again as 'WINDOWS-XPGuest'?? AND! I dont want this setup!! why is it always logging in as Guest?? how to change it?? I hope my information is enough to be understood clearly.. I'm Hoping for you help guys!!! Thanks!!!!
View Replies !
Snapshot Errors When Bulk Copying, ODBC Error
Hello. When pushing a snapshot from a SQL 7.0 P/D to a SQL 2000 subdscriber, I get ODBC errors during the bulk copy. If the snapshot is in Native format on the snapshot tab of the publication, the error returned is 'String Data, Right Truncation'. If I set the snapshot to character format, the snapshot fails on a different table further into the snapshot with 'Invalid character value for cast specification value'. I have tried adding the -Output parameter to the distribution agent, but the output does not provide any better error details (line, etc.)
View Replies !
Queries Against Linked Server To Informix Via ODBC Errors
What can be the reason(s) why I can't get data from a linked server using an ODBC datasource that works fast & fine from MS Access? I have an ODBC connection (System DSN) configured for an Informix ODBC driver. The Test button (belonging to this driver-setup) reports a successfull connection test. Getting data from this database by linking tables in MS Access works fast and easy. But I have tried for many days now to setup a linked server from SQL Server (2005) Creation goes fine, but as soon as I issue a query, (e.g. 'select * from infrem723...remotetable' or using 'openquery') I get the following error: --- Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "infrem723" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "infrem723". --- Why is Access able to read what "MSDASQL" cannot? I am desperate - can anybody help?Thanks a lot!
View Replies !
Getting ODBC Connection Errors With SQL Server 2000 On Windows XP
Hi all- I setup a new ODBC connection to MS SQL Server 2000 on Windows XP and keep getting the following errors when I try to either register a new SQL Server 2000 group within Enterprise Manager or test the new ODBC connection: Current configuration - MS SQL Server 2000 -Windows XP -ODBC 3.85.1117 Errors: I. Within SQL Server 2000 Enterprise Manager Error: SQL Server connection open II. When I test the ODBC connection: Microsoft SQL Server ODBC Driver Version 03.85.1117 Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. TESTS FAILED! Now here is what has me totally confused: I can use the command line ISQL to access the database on the server and IP is all correct and port is available. Any tips how to get this ODBC working? Thanks Ben Prusinski
View Replies !
How To Remove NT User After Restoring Back Up From Diffrent Domain
hi everybody. Scenario Company X has Sql server and domain x.com so on sql server they have logins XA XB XC Back of database Production was done database Production was restored in Company Y use Production select name from sysusers name ---- XA XB XC sp_dropuser 'XA' Server: Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12 User 'XA' does not exist in the current database. How to drop 'XA' ?
View Replies !
Domain User Belonging To Multiple Windows Group
If I have a domain user DOMAINuser1 who belongs to multiple window groups say DOMAINLookupConfigUsers and DOMAINAuditConfigUsers. In sqlserver, I would create two logins - DOMAINLookupConfigUsers and DOMAINAuditConfigUsers and matching users in the database. Then I grant LookupConfig role to the LookupConfigUsers user and AuditConfig role to the AuditConfigUsers user in the database. When DOMAINuser1 logs in, will it have both roles? I try to set this up but it does not seem to work. The domain user only picks up one of the role. Am I on the right track? If not, what is the proper way to grant multiple roles to a user when it belongs to multiple groups and each group has different privileges in the database.
View Replies !
Domain User Privilege For Connecting SQL Server 2000
Hi, My server administrator has created a few users as domain user privilege for connecting SQL server from my application. However it faild to connect, and with Domain Admin privilege, my app is running ok. I asked admin person to upgrade domain user privilege to connect SQL server, but he couldn't do this for security reason, and told it should work with domain user. Is it true for domain user to connect SQL server without any problem? Do I need to add the user, domain user, into Logins of Security inside SQL server Enterprise Manager? Or inside users of my database section of SQL server EManager? Thanks, dixon
View Replies !
Domain Logins To A SQL 2005 Server User Rights Assignment
Hi all,I must be going blind because i can not these options anywhere.We have a 2005 SQL Server running, what will become a live databaseasap. This is running currently within a domain. Unfortunately theusers of the database currently automatically log in using their domainusername. How can this be blocked, so that they have to use a sa stylelogin. (Is this setup on the ODBC driver end?).Secondly, if we do decide to use the domain logins, how can you assignthe rights of the domain users, to the database? sa and users createdin the software, have nice interfaces to do this, but domain usersagain i just cannot seem to find?I have the MSDN installed to look at the server instructions, but ifyou can point me in the right direction even in msdn it would be greatthanks.Many thanksDavid
View Replies !
Proper Syntax For Adding Object Name Owned By Domain User
I am receiving an error based on my query that is giving me the following error: Code: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Config'. I'm assuming that this is because the table was not made by dbo, but my domain account. The query is currently defined as: Code: SQL = "SELECT * FROM Config" but I'm assuming it needs to be defined with the syntax of ownername.objectname. My problem is when I change the string to this: Code: SQL = "SELECT * FROM sanm.APHinzeE.Config" I get this error: Code: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''. I tried to escape the slash using / but then I get the error on that. How do I specify my account name with the slash?
View Replies !
Trouble Logging In To SQL Server 2005 Express With Domain User Account
Hi all, I have a SQL Server 2005 Express edition instance set up on one server, and IIS on another server. The SQL Server process account is a domain user account, which I have added to the local groups that SQL Server created during installation (I originally used a local user account instead of domain account; however, the problem occurs with both). SQL Server runs fine, and if I set my IIS application pool identity to a domain admin, my web app can access the database and retrieve the data necessary. However, I have a domain user account that I want to use to run the app pool and retrieve the data. The domain user account is added to the IIS_WPG group on the web server. On the database server, I have created a login for the account, as well as added it to the db_datareader role of the database that is used for the site. However, the user is not able to connect to the SQL Server. I get the "Login failed for user <user account>" error in ASP.NET. I also tried connecting with SQL Server Management Studio, and I get the same error. I checked and the user has connect permission to the database server. With admin accounts, there are no problems logging in, etc. Any pointers are appreciated, Thanks, SA. Edit: I was able to find out that the State is 11 for the error. According to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx, this indicates "Valid login but server access failure." I am not sure how to resolve this.
View Replies !
Cannot Restore SQL 7 Db (user Errors)
I'm trying to copy a database from one server to another. I'm attempting to do this by restoring a SQL 7 DB from a saved disk backup. The FULL backup works fine. I'm only backing up "db1" with all objects, tables, etc. I then proceed to do a restore... but it keeps bombing on the restore part because the users are not present in the new database. I've also tried doing this as an export from on database to another. But it also fails because the users are not in the new database. Am I missing something? Do I need to copy the Master DB too? How do I copy the users w/o having to install each and EVERY one .... individually...? (There are 500+) Is there a better way to restore/copy a db from one server to another? I can't figure out why it's bombing out on the part where it adds users. (I'm trying to copy my database from prod to test... but exact mirror copies) Thanks!
View Replies !
FTS User Errors That I Can't Replicate!
I'm logging error messages for my ASP.NET application with errors being emailed to me as they occur. I continuosly get messages from one of my search pages that uses FTS with "Execution of a full-text operation failed. A clause of the query contained only ignored words". Having run both sp_configure 'default full-text language' and sp_help_fulltext_columns and the language is 1033 which is English US if I'm not mistaken so it shouldn't be a neutral word breaker... I've blanked all instances noise.eng and noise.enu, replacing all instances with a blank space and yet I'm still getting those errors! This is an example of one of the WHERE clauses where I'm using FTS: AND ( @SearchTermFTS IS NULL OR (CONTAINS(CurrentItem.Description2, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS)) ) In my ASP.NET code, I'm taking a string of search terms and processing each term to be like @SearchTermFTS = '"penci*" AND "mar*"' Am I doing something wrong? Please help, it's very frustrating!!
View Replies !
|
TRACKER
