How To Avoid Web Users To Connect To SQL Server Trought ODBC
Hi everybody,
i'll try to explain the problem with my bad english, so sorry.
In my firm i have a server (W2003 Server) with IIS 6.0 and SQL Server 2005 EE an it is joined in the main domain as all users and their workstation (window XP) are joined too.
The main role for this server is to be a web server and with IIS Manager I configured to verify user identities with Windows Integrated authentication without any anonymous access to web pages (ASP scripts).
I made a group called "Web Users" with read right on ASP scripts and his only one member is "Domain Users".
"Web Users" has of course rights to access this server from network.
This group is also a SQL Server login because it has rights to wiew an modify data at least in one db table trought ASP pages using ADO, but the problem is that they can also connect using ODBC.
Configuring SQL to accept only local connection i can avoid this, but as SQL Admin i can't connect too. So how is possible for web users interact with SQL only trought web pages ?
Thank you very much
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Users Are Unable To Connect To SQL Server 2005 Unless They Are In The Sysadmin Group
We are running SQL Server 2005 in a Windows 2003 domain and I have a situation where some of my users are unable to connect to the SQL Server unless they are a member of the sysadmin group. Any attempts by these users to login result in a login failed, Error: 18456, Severity: 14, State: 11 Which indicates that it is a valid user who does not have access to this SQL Server. I have been able to narrow the failures down to the following situation: Create a user, TestUser1, as a member of 1 domain local group TestGroup1 Give TestGroup1 access to SQL (standard public access to master) All good. Login succeeds. Add TestUser1 to another domain local group TestGroup2 Attempt to login to SQL Server -> login failed. Add the user explicitly -> login failed Add one of the groups to sysadmin -> login succeeds It seems that as long as the user is a member of more than one AD group, and none of those groups is a member of the sysadmin server role then the user is unable to login. Obviously having all of the users as sysadmin isn't a workable solution, has anyone seen this issue before? I have been able to replicate a similar situation in our test domain, but in that case the issue is resolved by adding the users explicitly to SQL Server (still not an ideal solution). Interestingly, if I run the same test in our test domain but use global groups, it works. But unfortunately the network admin tells me the groups must stay as local. Any help would be greatly appreciated. Regards, Daniel Watkins
View Replies !
View Related
I Can't Connect To Server Through ODBC....
Hi all I have problem with making Connection between two computer through SQLServer and ODBC. I have two computers which are members of a WorkGroup network with WindowsXP(sp2) installed. on one computer i have installed SQL Server 2000 Enterprise edition with MIX Authentication mode enabled. Also i have created a LOGIN (Sql Server Authentication) with System Administrator ROLE (SYSADMIN).in that sql server environment . But in another computer when i want to create an ODBC connection (ControlPanelAdministrative ToolsData Sources (ODBC)) to connect to mentioned Computer with Sql server,I receive the following Error: Access Denied...Sql Server doesn't exist. I have disabled Windows-XP firewall on both computers but still problem persists. By the way these two computer have one Administrator Account with DEFFERENT Passwords. Could anyone help me.? Any help greately would be appreciated. Kind Regards.
View Replies !
View Related
Using ODBC To Connect To SQL Server Database
I am trying out a simple ASP.NET application which includes access to an SQL Server Database. It works fine on my local machine when I connect to the SQL Server and use SQL commands (via C#) to access it. But my web hosting provider uses ODBC drivers for database access (they support the SQL database type). I would like to find out how I should connect to my SQL Server database and program the access in order for it to be ODBC compatible, so that I can deploy it to my web hosting server. I should also mention that I am using Visual Web Developer 2005 Express Edition. Thanks for any help or pointers. Kumar
View Replies !
View Related
Cannot Connect To Sql Server 2005 From Xp Client When Trying To Create ODBC Dsn
Newbie here, I am trying to link tables from an access 2003 frontend to sql server 2005 backend. I am doing this in a vmware test environment. I am using vmware server and running sbs 2003 and xp sp2 client. Both virtaul machine can talk to each other(using local host connection). I have tried to create a dsn to the sql server but i cannot connect. I can ping the sbs server through the command interface but the error i get when i try to connect is : Connection failed: Sql state: hyt00 sqlserver error: 0 microsoft odbc sql server driver timeout expired. spent a day trying various combinations - still no joy. Any help would be much appreciated
View Replies !
View Related
HowTo:Connect ODBC From 32bit To Sql Server 2005 (IA64)
Dear, I have application create by MsAccess and connect with Sql Server 2000 in x86 and now we transfer system to HP rx3600 Intel Itanium - Install Windows 2003 Server Enterprise (for Itanium) - Install Sql Server 2005 Standard Edition (IA64) and now we try to create ODBC connection from client for testing. But we can't not done it. Anybody can tell us how to create connection to sqlserver 2005 (ia64) Regards, Tee+
View Replies !
View Related
VBA + TSQL - GO Problem Passing SQL Script Trought VBA Excel
Hi, I am not sure where to post this question, because is related to both TSQL & VBA Excel. I am working under SQL SERVER 2000, and I have a query as described below: Code Snippet USE mydb SELECT Block ... GO ALTER TABLE Block... GO UPDATE Block... SELECT Block... If I writte the query as shown above directly in SQL SERVER, it does work. The issue is that I am generating the code trought VBA Excel, and when passing the SQL string to SQL, I get in SQL Server Managment Studio something like: Code Snippet "USE mydb SELECT Block ... GO ALTER TABLE Block... GO UPDATE Block... SELECT Block... " with the " marks at the beginning and at the end of the script. In order to avoid the marks ", I need to erase the new line (return) before and after the GO statement, replacing the new lines by spaces and then the code looks like this: Code Snippet USE mydb SELECT Block ... GO ALTER TABLE Block... GO UPDATE Block... SELECT Block... and DOES NOT work, getting Error because of the GO statement. Thanks in advance for any help, Aldo.
View Replies !
View Related
Connect SQL Server 2005 With ODBC Drive “SQL Native Client&&"
Hi, When I'm using SQL server 2005, and ODBC drive €œSQL Native Client€? I get an error when executing the below given code. Error Message: €œTransaction cannot start because more than one ODBC connection is in use.€? But this works well with SQL Server 2000 with ODBC drive "SQL Native Client" and in SQL server 2005 also when I used ODBC drive €œSQL Server€?. I used aTrgConn.Execute(€œBegin Transaction€?) and it's working properly. But unfortunately I cannot use this method, because I want to run the same code with Oracle ODBC as well. Is this a known issue in SQL Native client drive with SQL server 2005? Do you know a solution for this? Please Help.............. Thanks in advance. Code: Dim aTrgConn As New ADODB.connection Dim aCmdIns As New ADODB.Command Dim aCmdUpd As New ADODB.Command aTrgConn.Open sConnStr Set aCmdIns.ActiveConnection = aTrgConn Set aCmdUpd.ActiveConnection = aTrgConn aTrgConn.BeginTrans
View Replies !
View Related
Automating ODBC Changes For Multiple Users; Vbscript?
Hi, I need to change over 500 client ODBC connections as I am migrating a SQL 2000 database to a cluster and microsoft doesn't support renaming SQL clusters. I have a vbscript (below) which allows me to setup the appropriate ODBC connection but it doesn't allow me to specifiy using mixed mode sql authentication and subsequently a password for that account (though it does insert the username). Is there any way to do this?! If not is there a better way to automate mutiple odbc changes? If I can't figure out a way to do this I'm going to have to go round to every client manually as this migration has to happen in a week! :eek: Any help greatfully appriciated! Scrpit: Option Explicit 'Constants Const HKEY_CLASSES_ROOT = &H80000000 Const HKEY_CURRENT_USER = &H80000001 Const HKEY_LOCAL_MACHINE = &H80000002 Const HKEY_USERS = &H80000003 Const HKEY_CURRENT_CONFIG = &H80000005 'Variables On Error Resume Next Dim DataSourceName Dim DatabaseName Dim Description Dim DriverPath Dim LastUser Dim Server Dim Trusted_connection Dim DriverName Dim InputFile Dim iFSO Dim ifile Dim sComputer Dim sPath 'Value assignment DataSourceName = "ODBCname" DatabaseName = "Database" DriverPath = "C:WINNTSystem32sqlsrv32.dll" LastUser = "username" Server = "servername" Trusted_connection = "Yes" Description = "Connection_description" DriverName = "SQL Server" InputFile = "c:pclist.txt" Set iFSO = CreateObject("Scripting.FilesyStemObject") Set ifile = iFSO.OpenTextFile(InputFile) sPath = "SOFTWAREODBCODBC.INI" & DataSourceName 'Read and loop through the input file Do Until ifile.AtEndOfLine sComputer = ifile.ReadLine If (0 = CreateRegKey(sComputer, HKEY_LOCAL_MACHINE, sPath)) Then SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Database", DatabaseName SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Description", Description SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Driver", DriverPath SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "LastUser", LastUser SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Server", Server SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, sPath, "Trusted_Connection", Trusted_connection Else Exit Do End If 'Write in "ODBC Data Sources" Key to allow ODBC Manager list & manage the new DSN SetRegKeyStrValue sComputer, HKEY_LOCAL_MACHINE, "SOFTWAREODBCODBC.INIODBC Data Sources", DataSourceName, DriverName MsgBox (sComputer & " DONE!") Loop ifile.Close Set ifile = Nothing 'Create RegKey Function Function CreateRegKey(sComputer, hTree, sKey) Dim oRegistry Dim lResult Set oRegistry = GetObject("winmgmts:{impersonationLevel=impersonate}//" & sComputer & "/root/default:StdRegProv") lResult = oRegistry.CreateKey(hTree, sPath) If (lResult = 0) And (Err.Number = 0) Then CreateRegKey = 0 Else CreateRegKey = 1 MsgBox ("Create Key " & sKey & " Failed") End If Set oRegistry = Nothing End Function 'set RegKey Function Function SetRegKeyStrValue(sComputer, hTree, sKey, sValueName, sValue) Dim oRegistry Dim lResult Set oRegistry = GetObject("winmgmts:{impersonationLevel=impersonate}//" & sComputer & "/root/default:StdRegProv") lResult = oRegistry.SetStringValue(hTree, sKey, sValueName, sValue) If (lResult = 0) And (Err.Number = 0) Then SetRegKeyStrValue = 0 Else SetRegKeyStrValue = 1 MsgBox ("Set Value for " & sKey & " Failed") End If Set oRegistry = Nothing End Function
View Replies !
View Related
Win2K Users Cannot Connect To SQL2005 Database
Hi, I recently migrated our database from Access to SQL Server 2005. All the WinXP users can connect to the new SQL2005 database. But all the Win2K machines fail to log on. To diagnose the problem, I tried to connect from a Wind2K machine using an .udl file. The connection failed because "a provider failed to initialize". The SQL2005 server is residing on a WinXP machine. Users log on via SQL Server authentication layer using a dedicated login that only has read/write privileges to one specific database. Does anyone know a solution? Thanks in adance. Regards, Vladislav
View Replies !
View Related
Sending Messages To All Users Connect To SQL Serve
CREATE PROCEDURE [dbo].[NetSend2Users] @NotificationMsg VARCHAR(100) = NULL AS BEGIN /******************************************************************************************************* To send NET SEND messages to all the connected SQL Server users in an NT LAN, no 95, 98 ME machine... Input is Message to be sent *******************************************************************************************************/ DECLARE @DefMsg varchar (100) Set @DefMsg = 'SQL Server Shutting Down !!! Please Logout from the system' IF @NotificationMsg IS NULL Set @NotificationMsg = @DefMsg SET NOCOUNT ON DECLARE @msg VARCHAR(250) DECLARE @hostname sysname SELECT @hostname= min(RTRIM(hostname)) FROM master.dbo.sysprocesses (NOLOCK) WHERE hostname <> '' WHILE @hostname is not null BEGIN set @msg='exec master.dbo.xp_cmdshell "net send ' + RTRIM(@hostname) + ' ' + RTRIM(@NotificationMsg) + ' "' EXEC (@msg) SELECT @hostname= min(RTRIM(hostname)) FROM master.dbo.sysprocesses (NOLOCK) WHERE hostname <> '' and hostname > @hostname END SET NOCOUNT OFF END GO Kapil Arya
View Replies !
View Related
Will SQL 2000/2005 Block Me If More Users Connect To It Than I Have Licenses?
Hello our organization has never had any problems getting users to connect to our SQL servers but we have grown a lot over the past year or two. Does SQL Server actually block connections if they go over the license limit? I don't have access to the servers to see the model used but I have been asked to look into this. I couldn't find any information on this so I decided to ask you guys. Thanks in advance.
View Replies !
View Related
Cannot Connect With ODBC Using TCP/IP??
Win 2003 Small business server with IIS being used as a web server. Our client app can log in and run queries, but our web app when trying to log in gets the message, 'SQL server does not exsist or access denied' The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group. Any suggestions on what it might be??? :confused:
View Replies !
View Related
How To Connect Via ODBC
Hi, I would like to connect in SqlServer 2005 via ODBC SQLServer, how are the steps? 1 - How can I connect ODBC? 1.1 - I need SqlServer 2005 name - ok 1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication? Which one is the best option? Cheers, Alessandro
View Replies !
View Related
Connect Via Odbc
i have an sql express db on my webserver. now from another computer I am trying to creat an odbc connection to the sql server but when I enter in just the ip and the login and password it fails. Please advise me what I can do? what i really am trying to do is set up an access db on my home computer to be linked to an sql server express backend. I thought to do this with odbc - is this the correct way?
View Replies !
View Related
ODBC Connect Failed In SQL Job
I am running SQL Server 2000 sp4 in Win Server 2003. I have a DTS packages which connects to FileMaker 6 files via the ODBC driver installed with FielMaker. The DTS packages work correctly when executed directly. However, when executed from a SQL Server Agent job, the same DTS packages fail. Always with the same message: Error: -2147467259 (80004005); Provider Error: 16394 (400A) Error string: [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed Error source: Microsoft OLE DB Provider for ODBC Drivers Searching for info on the above message seems to indicate a permissions problem. However, I am running the jobs with an full administrator account. All connections and the FielMaker files reside on the one server. Any help on this would be greatly appreciated. Thank you.
View Replies !
View Related
Connect To ODBC Driver
Could someone tell me how to use a query with a "connection string" to connect to an ODBC driver and retrieve data from its tables. I am new at this and have been having a lot of trouble connecting from the SSIS manager. If someone has a tutorial on how to do this. I would really appreciate it. Thanks
View Replies !
View Related
Connect To SqlServer 2005 With Odbc
Hi all, I'm not a db guru and probably this is a very simple question for you, but I was wondering if it was possible to connect to a SqlServer using odbc without DSN. I mean, I'm trying to connect to the db server from a linux (Fedora Core 8) workstation, using odbc drivers, but it looks like I can do that only using a DSN connection and setting properly the odbc.ini file. It doesn't work, if I use a connection like this from a PHP script: $cn = odbc_connect("Driver={SQL Server};Server=MyServer;Database=MyDatabase", "MyUser","MyPassword") Does anyone know how to connect to SqlServer with a DSN-less connection? Could you explain me where is the error? I'm using SQLServer2005, Fedora Core 8 with the last FreeTDS installed. Please help! Thanks million in advance.
View Replies !
View Related
Win32::ODBC Connect To MSSQL
Hi, I wanted to know if there is a way to connect to my MSSQL without having to setup a datasource in the control panel. Perferably I want to locate the database within my perl code instead. I don't want to have to setup a datasource each time I need a different database. Perhaps there is a way to pass the name of the database along with the username and password through the command line. Any suggestions? Thanks.
View Replies !
View Related
Cannot Connect Using ODBC Or OLEDB Provider
HI, I installed SQL Server 2005 as a named instance. While I can connect to my server using SQLCMD or SSMS, SSIS; I cannot create a DSN entry that can connect to it, use OLEDB or connect using OSQL. I get the following message when I try to connect to the server using these technologies: "Cannot generate SSPI context" I also have a SQL Server 2000 named instance on my PC and I do not have these kind of problems (connecting using ODBC, OLEDB or OSQL). Is there a configuration setting that I am missing? Thank you, Ccote
View Replies !
View Related
ODBC Tries To Connect Through The Wrong Port
Hi, I've been running some tests with a 3rd party application during the last few days, but the ODBC doesn´t seem to be working well. The ODBCs are configured to go through specific ports, since there's a firewall between the server (production area) and the database (which is located in the dev area). If i press the TEST CONFIGURATION button after i configured the ODBCs, the test is successful, and the log file of the firewall monitor shows that the server is connecting through the designated ports. But when i run the 3rd party application, the queries fail, showing an error that says "The server cannot be found or you don´t have access", after this error, another one appears, saying something like "Connection().opened..." - unfortunately I don't have the actual text, I'll try to post it as soon as i get them . Just to make sure that the 3rd party app is doing its job, dev team wrote a simple VB6 app to query the database, and it shows the same error. Both apps are running well in the dev environment, since dev machines don't have to go through the firewall, and both apps are using the ODBC configured in the same way as the server. I could think that the problem is the firewall, but the firewall logs show that the production server is trying to use ports 1433, 1434, 445 and 139, and there isn´t a single entry showing activity for the ports specified on the ODBCs configuration. The database server is running SQL Server 2000, the dev pcs are running Windows 2000, and the ODBC driver version is 2000.85.1117.00. On the Production environment the server that is trying to access the database is running Windows 2003 Server Ent Ed. SP 1 , and the ODBC driver version is 2000.86.1830.00 I hope some one outthere has any ideas to solve this problem, or at least any idea of what is causing this error, because i´m running out of them. Thanks in advance. Efrain Morales
View Replies !
View Related
Connect Using ODBC Connection In Vbscript
I am trying to connect to a database and run a query using vbscript. The problem I have run into currently is that I can not get the connection to open even though I know the DSN name it still says it can not find it. I am fairly new to vbscript so I am not sure exactly what it is looking for in the connection string so that it will find the database. Any ideas?
View Replies !
View Related
ODBC Connect Times Out, But 2nd Time Works
When I begin Enterprise Manager and open a connection to a Server, it fails with a timeout error. But if I do a refresh and then connect again, it immediately works. I have had similar symptoms setting up a data source for ODBC. When you initially logon to SQL Server to define the connection it times out. But then if you immediately try again it succeeds. Furthermore one of my application programs fails to work (due to the timeout) on systems that have this behavior. I have had these symptoms occur on 2 diferent workstations, but other workstations access the SQL Server with no problem. All systems are WinNT 4.0; the engine is SQL Server 7 with SP2. The timeout is defined as 15 seconds so should be long enough. Does anyone know what is going on, or how to fix it?
View Replies !
View Related
Runtime Connect Error To ODBC System DSN
Hello, I have created an SSIS package to retrieve data from a Lotus Notes database using the NotesSQL 3.02g ODBC driver. In SSIS design mode, I can connect to the Notes datasource using the following connection string without any validation errors. uid=UserID;Dsn=LN_Costs; I have tried other variations of the connection string including every possible connection string parameter available to the driver as follows. server=Server_Name;uid=UserID;Dsn=DSN_Name;Driver={Lotus NotesSQL Driver (*.nsf)};database=costing/productcost.nsf;username=UserID;encryptpwd=encrypted_password;maxsubquery=20;maxstmtlen=4096;maxrels=20;maxvarcharlen=254;keeptempidx=1;maxlongvarcharlen=512;showimplicitflds=0;mapspecialchars=1;threadtimeout=60; Using the above connection strings in SSIS design mode, the datasource test succeeds, and an sql select statement in a datasource reader returns the table structure with no error. However, when I try to run the package, I receive the following error. SSIS package "Sales Data Load.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Error: 0xC0047062 at Data Flow Task, DataReader Source 2 [408]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction) Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source 2" (408) failed validation and returned error code 0x80131937. Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. SSIS package "Sales Data Load.dtsx" finished: Failure. Furthermore, I have packages configured in SQL 2000 DTS to use the same system dsn without any errors. Why doesn't this work in SQL 2005 SSIS? Thanks.
View Replies !
View Related
Cannot Connect To SQL 2005 Using System DSN ODBC Connection
I am running SQL 2005 SP1 on Win 2003 Std x64 SP2. I get an error trying to connect using an ODBC System DSN connection. The ODBC connection gets the following error: Connection failed: SQLState:'28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' The SQL Server logs the following error: 18456, Severity: 14, State: 8. I have tried this with several SQL accounts. I am able to login to the SQL Manager with the accounts without issue. It is only when trying to connect via ODBC that I get the error. I am currently downloading SQL 2005 SP2 to see if this will help with the issue. Any other ideas would be greatly appreciated. Thanks. John
View Replies !
View Related
Runtime Connect Error To ODBC System DSN
Hello, I have created an SSIS package to retrieve data from a Lotus Notes database using the NotesSQL 3.02g ODBC driver. In SSIS design mode, I can connect to the Notes datasource using the following connection string without any validation errors. uid=UserID;Dsn=LN_Costs; I have tried other variations of the connection string including every possible connection string parameter available to the driver as follows. server=Server_Name;uid=UserID;Dsn=DSN_Name;Driver={Lotus NotesSQL Driver (*.nsf)};database=costing/productcost.nsf;username=UserID;encryptpwd=encrypted_password;maxsubquery=20;maxstmtlen=4096;maxrels=20;maxvarcharlen=254;keeptempidx=1;maxlongvarcharlen=512;showimplicitflds=0;mapspecialchars=1;threadtimeout=60; Using the above connection strings in SSIS design mode, the datasource test succeeds, and an sql select statement in a datasource reader returns the table structure with no error. However, when I try to run the package, I receive the following error. SSIS package "Sales Data Load.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Error: 0xC0047062 at Data Flow Task, DataReader Source 2 [408]: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction) Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "DataReader Source 2" (408) failed validation and returned error code 0x80131937. Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation. Error: 0xC0024107 at Data Flow Task: There were errors during task validation. SSIS package "Sales Data Load.dtsx" finished: Failure. Furthermore, I have packages configured in SQL 2000 DTS to use the same system dsn without any errors. Why doesn't this work in SQL 2005 SSIS? Thanks.
View Replies !
View Related
Cannot Connect To SQL 2005 Using Vista ODBC Administrator
Here's the context: Database server: - Remote machine running SQL 2005 Standard as a named instance - Named pipes and TCP are enabled for remote connections - SQLBrowser service is running - Listening on default named pipe (\servernamepipeMSSQL$instancenamesqlquery) Client: - Vista Business machine - Not in same domain as server, but on the same network (via Cisco VPN) - SQL 2005 Express is installed (for use with local databases) - Windows Firewall enabled - Running Symantec Antivirus, Corporate Edition Connectivity: - I CAN connect to SQL 2005 databases on the remote server using "nperverinstancename" - I CAN connect to SQL 2005 databases on the remote server using Excel 2007 The problem is that I cannot successfully create an ODBC datasource using the "ODBC Data Source Administrator" application. I'm using the "SQL Server" driver and trying to create a System DSN. I'm also running the tool with elevated permissions. - When I try to use "servernameinstancename" as the server and TCP as the connection type, I get this error: Connection failed: SQL Server Error: 18452; "[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ''. The user is not associated with a trusted SQL Server connection. - When I try to use "npervernameinstancename" as the server and Named Pipes, I get this error: Connection failed: SQLState: '01000'; SQL Server Error: 1326; [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()). Connection failed: SQLState: '08000'; SQL Server Error: 17; [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Help! I've really been beating my head against the wall on this one. It all works just fine with a Windows XP client machine.
View Replies !
View Related
Can't Connect To The ODBC Database Named Aspol54
can any one provide any suggestions to help this error i installed automation studion 5.4 and the program will not run on my laptop. i traced the data below when i try to start the program. AsProjet db0-b5c ENTER SQLAllocEnv HENV * 015CF6B0 AsProjet db0-b5c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x015CF6B0 ( 0x015e1540) AsProjet db0-b5c ENTER SQLGetEnvAttr SQLHENV 015E1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attribute 201] SQLINTEGER 4 SQLINTEGER * 0x0013E380 AsProjet db0-b5c EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 015E1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attribute 201] SQLINTEGER 4 SQLINTEGER * 0x0013E380 (1567744) any help would be great. tks
View Replies !
View Related
SQL 2005 Express - Connect To ODBC Database
Is it possible to create a connection to an ODBC database from within the SQL Server Management Studio Express. I want to create and save the connection settings and use them to reconnect when needed. Is this possible? Do I have to create the connection in Express VB.Net or can it be setup as a saved link to the external ODBC database? Can this be done to an MS Access database? Thanks, John
View Replies !
View Related
Error 18456 When Trying To Connect To 2005 Using Odbc
Hi all I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error: [SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]] Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility. any ideas ? Regards, Waff I found this out: The server collation is defined to: Latin1_General_CI_AS If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should. How do you use a id in lowercase and connecto via ODBC ?
View Replies !
View Related
Unable To Connect To An ODBC Text File Source
Hi one of the data sources I've set up is through an ODBC to a text file which logs errors through our fax software. The report connects to the data source in the report designer but when it's deployed, the report "Cannot create a connection to data source 'FaxMaker'" in the RDL I have. <DataSource Name="FaxMaker"> <DataSourceReference>FaxMaker</DataSourceReference> <rd : DataSourceID > 3556c0b4-9281-451e-966c-f279ab6cc78e</rd : DataSourceID> </DataSource> Can anyone advise me on what I'm missing. Thanks Steven
View Replies !
View Related
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
Hi Everybody, On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help. Thanks, Arif Server Error in '/' Application. -------------------------------------------------------------------------------- ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.] Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27 Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838 Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80 Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731
View Replies !
View Related
How To Avoid Having Locked Tables During Update In Sql Server 2005?
We are running a shopping mall in Korea and got a database including a table of 4 million product prices, which is to be updated hourly basis. Updating 4million records requires at least 10 minutes to complete. During the update, our shopping mall exposed to customers does not respond quickly in fact very very slowly and we investigated and found out that many tables of SQL database during the update were being locked. As you know, site speed is top priority. We studied and found out that there are two ways to avoid having locked tables during update, those are "read uncommitted" and "snapshot" using the following lines. set transaction Isolation level read uncommitted set transaction Isolation level snapshot We tried numerous times the above two lines and still find our tables being locked during update and our customers are being disappointed. My questions: 1. Is it possible at all in view of "the state of the art" to avoid having locked tables during update of 4 million records ? 2. if it is possible, would you please teach me like I am the beginner of database studies? For your information, we are using 2005sql (64bit) in Windows 2003 (64bit). Sincerely Daeyeon Jo
View Replies !
View Related
|
TRACKER
