Fail To Connect Via Sockets To SQL Server
Apr 24, 2000
Background:
NT EE, MSCS, SQL 7.0 in Active/Passive environment. Add'l SQL installed on Passive server is hosting our Report database(any tips on Log Shipping?).
Anyway, I am unable to configure a client to connect to the secondary server via TCP/IP sockets.(Error 10061). I use the standard port 1433 and I've tried using both the name and the IP address for the server name.
What it looks like it's doing is only listening to port 1433 on the hearbeat nic. The reason I believe this is because when I ping the server name from that server, it returns a succesful ping, but using the heartbeat(seperate subnet)nics IP address.
Ping from a remote box works fine(DNS/Wins Resolution), and I connect fine with Named Pipes.
Both the primary and secondary server display the same results, the difference appears to be that only a virtual server in a clustered environment can have TCP/IP clients connect to it.
Can anyone verify this for me? Thanks a bunch...
MS says to go Active/Active and I am willing to do so, eventually.
Looking for a short term solution.
I'm not able to listen on a different port(again, appears only a Virtual server can).
Pete Karhatsu
View 3 Replies
ADVERTISEMENT
May 15, 2008
Hi !
I try to connect to a database on my localhost using sqlcmd. For the records: Remote connections are allowed ! I don't have any issues to establish a connection using SSMS.
S:DBWorkFolder>sqlcmd -U razorblade -P xxxxx -S localhostzen_dev4
This is what I get:
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Any help appreciated !
Thanks: Peter
View 1 Replies
View Related
Jul 25, 2006
Message:
Cannot connect to server
additional information
- failed to retrieve data for this request.(microsoft.sqlserver.smoenum)
- connect to SSIS service on machine "server" failed:
error loading type library/dll
- connect to SSIS service on machine 'server' failed :
error loading type library/dll
any idea?
soonyu
View 3 Replies
View Related
Dec 3, 2004
I am running Windows 2003 Standard edition with IIS and SQL 2000 SP3a installed on it.
The web clients use ASP pages which use DSN to connect to SQL 2000 database. It has been working fine since last 1.5 years except 2 days ago when I faced this error suddenly on server:
In accessing any ASP page, it said:
[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets_SQL_Server_does_not_exist_or_access_den ied.
On SQL Server error log, this was the entry at that time which I found:
SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
The server (including SQL Server and agent service) were last stopped atleast a couple of days before, so it was not the problem about startup.
To troubleshoot, I restarted SQL Server and it worked for some time.
Then again on ASP pages, I found this error:
|80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]General_network_error._Check_your_network_document ation.
I checked the error logs of SQL server and didn't find anything.
Only entries were that the SQL is starting database, ports and IPs on which it is listening etc. The usual stuff. No errors in starting.
The SQL Agent log showed following errors:
2004-11-30 04:45:33 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2004-11-30 04:45:33 - ! [382] Logon to server '(local)' failed (JobManager)
2004-11-30 04:45:36 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE
I don't understand what was the problem. It first occured when nothing on server was changed, next it occured 30-32 hours later, and still now it hasn't happened again.
Does anyone know what can be wrong?
Thanks.
View 5 Replies
View Related
Mar 6, 2006
I have an application that runs as a windows service that uses an ODBC connection. I recently upgraded
the database from MSDE -> Sql Express.
Everything works fine (connectivity, etc) when I start my application manually. When I attempt to start as
a service I get connection timeouts. After a small window of time, I can rerun my service and things connect
just fine.
As a workaround I'm planning on having my service connect, fail, slep 5 seconds and then attempt a 2nd connection.
I really hate to do this and was wondering if anyone had any ideas. Below is the error log I get after I reboot
my PC.
I'm attempting to connect as: "TestMachineNameLocalServerUserNameHERE" to the DB of "MyDatabase". (Names have been
changed so I don't catch flack from my company for posting specific details :))
Connection is done via ODBC via a system DSN to "localhost". I can sucessfully test connect here, but I can only
do this after the services have all started.
Any ideas?
Thanks,
Andy
========================================================================================
========================================================================================
Error log after startup
========================================================================================
========================================================================================
2006-07-06 08:09:39.00 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-07-06 08:09:39.00 Server (c) 2005 Microsoft Corporation.
2006-07-06 08:09:39.00 Server All rights reserved.
2006-07-06 08:09:39.00 Server Server process ID is 460.
2006-07-06 08:09:39.00 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-07-06 08:09:39.00 Server This instance of SQL Server last reported using a process ID of 3188 at 7/6/2006 8:08:04 AM (local) 7/6/2006 12:08:04 PM (UTC). This is an informational message only; no user action is required.
2006-07-06 08:09:39.00 Server Registry startup parameters:
2006-07-06 08:09:39.00 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-07-06 08:09:39.00 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-07-06 08:09:39.00 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-07-06 08:09:39.09 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-07-06 08:09:39.09 Server Detected 1 CPUs. This is an informational message; no user action is required.
2006-07-06 08:09:39.34 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-07-06 08:09:39.35 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-07-06 08:09:39.37 spid5s Starting up database 'master'.
2006-07-06 08:09:39.79 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-07-06 08:09:40.09 spid5s SQL Trace ID 1 was started by login "sa".
2006-07-06 08:09:40.29 spid5s Starting up database 'mssqlsystemresource'.
2006-07-06 08:09:41.17 spid8s Starting up database 'model'.
2006-07-06 08:09:41.17 spid5s Server name is 'TestMachineName'. This is an informational message only. No user action is required.
2006-07-06 08:09:41.18 spid5s Starting up database 'msdb'.
2006-07-06 08:09:41.48 Server A self-generated certificate was successfully loaded for encryption.
2006-07-06 08:09:41.48 Server Server is listening on [ 'any' <ipv6> 1433].
2006-07-06 08:09:41.50 Server Server is listening on [ 'any' <ipv4> 1433].
2006-07-06 08:09:41.50 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ].
2006-07-06 08:09:41.50 Server Server local connection provider is ready to accept connection on [ \.pipesqlquery ].
2006-07-06 08:09:41.50 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2006-07-06 08:09:41.51 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2006-07-06 08:09:41.51 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-07-06 08:09:42.29 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:42.29 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:42.29 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:42.29 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: 192.168.1.31]
2006-07-06 08:09:43.48 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:43.48 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:43.48 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:43.48 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:43.89 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:43.89 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:44.00 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:44.00 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:44.15 spid8s Clearing tempdb database.
2006-07-06 08:09:44.21 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:44.21 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:44.25 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:44.25 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:44.96 Logon Error: 18456, Severity: 14, State: 16.
2006-07-06 08:09:44.96 Logon Login failed for user 'TestMachineNameLocalServerUserNameHERE'. [CLIENT: <local machine>]
2006-07-06 08:09:44.96 spid8s Starting up database 'tempdb'.
2006-07-06 08:09:45.32 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-07-06 08:09:45.32 spid11s The Service Broker protocol transport is disabled or not configured.
2006-07-06 08:09:45.32 spid11s The Database Mirroring protocol transport is disabled or not configured.
2006-07-06 08:09:45.46 spid11s Service Broker manager has started.
2006-07-06 08:09:46.00 spid51 Starting up database 'MyDatabase'.
2006-07-06 08:09:46.10 spid51 Recovery is writing a checkpoint in database 'MyDatabase' (6). This is an informational message only. No user action is required.
View 4 Replies
View Related
Nov 3, 1999
Assuming that IP/Sockets was added during the SQL installation.
Forgetting the known reasons for selecting them (Integrated security, etc.)
I've never fully understood why one connect method worked in some cases and the other did not. Can someone attempt to convey what the real differences are. What are required to use Pipes/Sockets. Do you need to be in same Workgroup/Domain, have a name server, etc.
I believe we all could benefit from a good explanation of this.
Thanks for any input,
Dano
View 2 Replies
View Related
Sep 21, 1998
A Win95 PC was having some TCP/IP problems that were corrected by the helpdesk. After that, SQL 6.5 client utilities were not working properly.
When trying to configure TCP/IP sockets in the Client Config, there is an error "Unable to locate the Net Library in Path". The necessary files appear to be in the correct path when I choose locate. I deinstalled and reinstalled the client utilities with no luck.
Also, when I enter the SQL Enterprise Manager, the error "Network Communications layer not loaded" appears.
Any ideas?
Thanks,
Christi Fischer
fischerc@mail1.monmouth.army.mil
View 1 Replies
View Related
Aug 9, 2001
Has anyone encountered this error and found a solution?
A batch process received this error for the first time last night.
We are running SQL 7 on an NT4 server, and the client machine is a Win2K box.
The process is a VB application, using ADO to connect to the database.
We are using TCP/IP protocol.
We were using the Named Pipes protocol in the past, but changed to TCP/IP a few weeks ago, because we kept getting a "ConnectionWrite(GetOverLappedResults)" error, and found information that stated the error was due to the Named Pipes protocol, and the solution was to switch to TCP/IP.
FYI, since switching protocols we have not seen the ConnectionWrite(GetOverLappedResults) error, and we used to get it everytime the process ran.
Any help or suggestions are appreciated.
If any further information about our systems or the process would help, let mw know and I will provide it.
Thanks.
View 2 Replies
View Related
Sep 4, 2001
We would like to use dns entries (CNAME) to create transparency between server infrastructure and logical servernames. So we could physically move databases onto another server and changing the dns entry without reconfiguring all client applications.
Old situation:
- Financeapplication connects to SERVERA (wins) through a .ini file.
New situation:
- Financeapplication connects to finserver.mydomain.be (CNAME)
- finserver.mydomain.be points to servera.mydomain.be (A record) in dns
- servera.mydomain.be is refering to the ip address of SERVERA
We tried to connect and got a 'get_overlapped_results' (clientside) when using a dns name in combination with named pipes. At the server we are getting this error:
Error: 17832, Severity: 18, State: 8
2001-08-24 13:10:16.64 ods Connection opened but invalid login packet(s) sent. Connection closed.
Connecting to the wins name of the server does work! Connecting to the dns name also works when using tcp sockets instead of named pipes.
Though, on some client pc's this does work with named pipes too, but we couldn't find any regularity or logic when it works or when it doesn't (service packs, mdac versions, NT/95/98/2000, ... etc).
We also noticed that integrated security works with tcp sockets when using dns names, but it doesn't when using wins names.
Does anyone have a clue?
Kurt.
View 1 Replies
View Related
Sep 25, 1998
We are having some problems using TCP/IP connection and was wondering what the benefits are to using this versus Named Pipes. The company that provides our software stated that this would improve performance but I do not see it and I am getting a lot of errors connecting. This also locks many of the users and I end up having to stop and start the database to clear the locks because there are so many. Would it be better to place the clients on Multi-protocol. It seems more powerful to use but I wanted to get some feedback from some people that may have dealt with this issue before.
Thanks,
View 1 Replies
View Related
Aug 21, 2007
Since we change the web server to window 2003, we occasionally receive the message
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())
We use ASP and ODBC to access sql 2005. I have specified to use TCP/IP and port 1433 in ODBC.
Any idea to solve it?
Thank you in advance.
View 3 Replies
View Related
Jul 9, 2007
Hello,
One of our customers is experiencing a problem that makes me think there is a network problem, because we make a request and never return from the driver, but the transaction is still open on the server awaiting the next command (and holding locks blocking other processes). I see a number of other driver writers have described similar problems, and their "workaround" is to set SO_TIMEOUT on the sockets (setSoTimeout) they create which is a last defense so that the transaction won't block forever.
I do not see this in the API documentation- how can I set this? Many other drivers use a connection string parameter, do you offer the same?
Is there any logging I can enable that can show me for sure that the driver is waiting indefinately on socket.read (thats not terribly expensive)?
Thanks,
Steve
View 10 Replies
View Related
Oct 24, 2007
Hello all,
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
View 6 Replies
View Related
Nov 14, 2006
I have searched and could not find an answer for this one I read log and it said
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
how do I fix this?
View 7 Replies
View Related
Dec 12, 2006
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
These are my values in my Java app web.xml -
<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.
And yes, the port is 1055 - I checked to find it.
I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).
Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?
View 7 Replies
View Related
May 10, 2008
I tried to install SQL Server 2005 (x64) Standard Edition on Windows Server 2003 R2 (x64) Standard Edition. My box meet the requirement. But I got the following error when the installing progress was just about to begin:
Error 1016:Could not access network location k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio.
(this is exactly what i saw in the system log)
what does it mean?? i am totally confused...what the hell is the k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio????
Can anybody give me a hand? thanks...
View 5 Replies
View Related
Jun 7, 2005
Hi!Currently we only have one SQL Server database in our production system. I would like to add one more SQL server 2000 database. I would like to configure them so that both server share the load and Failover. I did some research and I found that I can do this by installing the OS (Windows 2000 Server Enterprise Edition) and SQL 2000 Enterprise Edition on both machines using the windows clustering. I want both servers to be active. They both have a copy of the production data. What I don't know is that, if it is possible to synchronize the data on both databases using SQL Server Replication utitlites. From what I know one SQL Server must be Publisher and one Subscriber. Can one sql server be both? Because I want both sql server to be identical. Can I set up replication between more than 2 servers? We just need to add one server for now but I would like it to be expandable. In the future we may need more.So Please provide me some ideas and answers about the following.1- Can two SQL Server cross replicate (both update each other in order to be identical)?2 -Does replication work beyond 2 servers.?3- If you were to set up a production database; what do you recommend considering the load balancing and Failover using Windows 2000 Server Enterprise Edition and SQL Sever 20000 Enterprise Edition?Thanks,Michael
View 3 Replies
View Related
Sep 19, 2000
For some reason my backups (Transaction log and full backups) have started failing. When looking at the job histoy for the step that failed it reports:
*****(0.011 MB/sec). [SQLSTATE 01000] (Message 3014) Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed. [SQLSTATE 42000] (Error 3023) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). NOTE: The step was retried the requested number of times (3) without succeeding. The step failed.*****
I have tried running the SQL for the step manually and I get:
Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
Server: Msg 3013, Level 16, State 1, Line 36
Backup or restore operation terminating abnormally.
The step is only determining what day of the week it is and putting it in to a '@bkupday' variable then: "BACKUP LOG [model] TO @bkupday WITH NOINIT , NOUNLOAD , NAME = N'Model Log Backup', NOSKIP , STATS = 10, DESCRIPTION = N'Model log backup', NOFORMAT" for each database and log.
This had been working fine, but for some reason has now started playing up. (trying to workout wether this ties in with when I started merge replication of one of the DBs)
Any one got any ideas as to what might be causing this as it's happened for a couple of nights now?
Cheerz.
View 2 Replies
View Related
Jul 9, 1998
I have a client that has a table that after recreating the database from scratch it has a table that can not drop one of the eight indexes. Has anyone seen something like that? What did you do?
Thanks,
Steven Dunker
View 1 Replies
View Related
Jan 3, 2007
Greetings,
First I am fairly new to SQL Server 2005 Clustering so this is why I was to see if any of you might be able to help me.
Are current setup is as follows:
CRM1 SERVER 2K3 R2 xxx.xxx.xxx.74
CRM2 SERVER 2K3 R2 xxx.xxx.xxx.75
HP MSA1000 xxx.xxx.xxx.75
MSDTC IP xxx.xxx.xxx.77
SQL INSTANCE xxx.xxx.xxx.78
Now are CRM guys are trying to connect to xxx.xxx.xxx.78 for there SQL instance or RDP into this ip address and they can’t…Now the question is should they be able yto logon to the SQL Instance via RDP?
Thanks,
CujoX
View 3 Replies
View Related
Jan 8, 2007
Posted - 09/07/2005 : 15:32:52
--------------------------------------------------------------------------------
Hi, i need help about restore a DB
I did a backup of a database using SQL Server Management Studio, but when i try to restore my database now, i get this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'Athenas'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
What do i doing so bad??
Thanks for ur opinions and help.
Regards
------------------------------------------
seyha moth
View 8 Replies
View Related
Jun 18, 2007
Hi group,being pretty new to setting up sql server, I am stuck. Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:<%Set Conn = Server.CreateObject("ADODB.Connection")ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"ConStr = ConStr & ";UID=someUser;PWD=somePassword" ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"Conn.Open ConStrConn.CloseSet Conn = Nothing%>The IP number is the webserver my router points to on port 80.But get an HTTP 500 error and "The page cannot be displayed"Any suggestions as to what I am doing wrong here, would be very much appreciated.I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.Best wishesFCH
View 1 Replies
View Related
Nov 26, 2006
i installed sql server express, but i did not select to use mixed mode (the reason being for this that every time i did i got a install coruption error) i want to be able to connect the database remotly using the sqlservers jdbc driver. however i need a user name and password. therefore to do this i believe i need to be able to acess the database remotly.
ive tried everthing:
1. changing the surface area remote conenctions to allow remote connections using tcp and ip only
2. restarted the database
3. restarted the server
4. restarted the browser
5. checked the tcp/ip settings are enabled.
but when i do the follwing in command line i get this:
C:>osql -E
[SQL Native Client]VIA Provider: The specified module could not be found.
[SQL Native Client]Login timeout expired
[SQL Native Client]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.
which indicates that its still not allowing remote conenctions, any ideas?
View 4 Replies
View Related
Aug 2, 2007
I am working with the ssis packages.I am working in the development enviroment.Once i place them on the server all my connection to text files fails.I dont want to sit and Keep changing with respect to server again and again.
What is the best way to set connection like for example:in my development it can be on e:data folder
But on server F:Data
With me changing again and again, can this be set within the package in the development environment.
Please le me know.
View 4 Replies
View Related
Feb 18, 2008
Hi everyone
i get an error messgae running the following code
DECLARE @mailist VARCHAR(max)
SET @mailist=''
SELECT TOP 1 @mailist=@mailist + email +';'
FROM
email.dbo.mytable
SET @mailist=STUFF(@mailist,LEN(@mailist),1,'')
SET @mailist='''' + @mailist + ''''
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=@mailist,
@subject='mysubject',
@body_format='html',
@body=
'
<html>
<head>
<title>
problems with send_dbmail
</title>
</head>
<body>
this is not working
</body>
</html>
'
The error says:
quote:
Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address)
At the other hand, if i assign a straightforward @recipints address such as
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=my@mail.com
It works
Anybody know why ?
Thanks
View 11 Replies
View Related
Sep 27, 2007
Hi,
A few months ago, I was trying to install SQL Server 2005 SP2 on a cluster (Active-Active), the Cluster has 3 instances, 2 lives in one node and the other one in the other node. When I try to make the deployment an error message appear, I do not have the error right now but it€™s something like €œCould not connect to the passive node, installation failed€?. The worst part of the error was all instances shut down and I couldn€™t bring on line and I have to reinstall all instances. I need to install SP2 but I€™m a little afraid fail again. Do you know the best way to deploy the SP2 on a cluster? Maybe move all instances in one node before install SP2? Can you help me with your comments. Do you think I have problems with the windows cluster?
Thanks and Regards,
View 3 Replies
View Related
May 16, 2006
Hi all,
When i attempted to connected to Microsoft SQL Server 2005 Express via ASP.NET 2.0 application, it seems to throw the following error.
I had set up the Protocols for Express (TCP/IP and Named Pipes are both enabled) to allow remote connections using both TCP/IP and named pipes.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
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: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.sqlquerytool_aspx.Button_Click(Object s, EventArgs e) +49
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
I have been battling with error for 5 solid hours. Please help me
thank you in advance
View 1 Replies
View Related
Jul 23, 2005
I have a SQL Server job, which runs mutiple steps. One of the steps(step 3) looks for a record in the database. How can I explicitly failthe SQL server job if the database record does not exist?
View 2 Replies
View Related
Jul 20, 2005
We have SQL Server 2000 Standard and recently moved from Exchange 5.5to Exchange 2003. This problem occurred both before and after thee-mail change.We would like to send notifications of failed jobs to multiple peoplein case one person happens not to be in on the day there is a problem.Setting up an operator with an e-mail name that combines twoaddresses seems to work ok as long as we use a format like thefollowing:smith_john; jones_maryorJoin Bytes!; Join Bytes!However, when we add a third name, we start getting problems. Thefirst and third accounts listed get the message but the second onedoes not -- apparently because the address gets corrupted. Forexample (based on the message received at one of the good addresses),a message sent to:Join Bytes!; Join Bytes!;Join Bytes!goes to Smith and Jackson successfully but Jones' address is corruptedto:Join Bytes!omand, of course, fails.From some other testing, it appears that the last three characters ofthe first address always get appended to the end of the secondaddress.Has anyone else run across this? If so, is there a known fix? I hadhoped Exchange 2003 would fix the problem. Most likely, we will trysetting up a personal distribution list under the account from whichthe messages are sent. I just wanted to give one more shot to findingthe problem -- both because I would like to know and because beingable to string together addresses is a little easier than having to gothrough the person who can give us access to the account to set thePDL.Thanks.Jonathan LevyChicago Department of Public Health
View 1 Replies
View Related
Feb 12, 2009
We get the below error while performing a distributed transaction on linked server. We have several linked servers configured in the source server and all of them succeed with the distributed transaction except on one.
Â
We did all the basic troubleshooting and moreover the distributed transactions work fine if we use a remote server instead.
Error:
OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" was unable to begin a distributed transaction.
Â
 Test code:
begin distributed transaction
select top 10 * from [SERVERNAME.REDMOND.CORP.MICROSOFT.COM].master.sys.objects
 ROLLBACK
Â
Source server : Â Â
Microsoft SQL Server 2008 (RTM) - 10.0.1779.0 (X64)
      Nov 12 2008 12:10:04
      Copyright (c) 1988-2008 Microsoft Corporation
      Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (VM)
Â
Target server : Â Â
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
      Jul 9 2008 14:43:34
      Copyright (c) 1988-2008 Microsoft Corporation
      Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
View 30 Replies
View Related
Jul 28, 2007
I have Visual Web Developer worked on my computer, but I can't make SQL Server work for data-driven. I have uninstalled and install VWD from http://msdn.microsoft.com/vstudio/express/downloads/default.aspx , the same Error message...... "..unexpected fail to install SQL server...", the copy of Summary.txt as below:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 Setup beginning at Sat Jul 28 06:54:25 2007
Process ID : 3324
c:8845baf7ee339eaf6setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/6/28 6:54:24
Complete: LoadResourcesAction at: 2007/6/28 6:54:24, returned true
Running: ParseBootstrapOptionsAction at: 2007/6/28 6:54:24
Loaded DLL:c:8845baf7ee339eaf6xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/6/28 6:54:25, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: -2146893813
Windows Error Text: Key not valid for use in specified state.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2148073483
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3324"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/6/28 6:54:25
Complete: ValidateWinNTAction at: 2007/6/28 6:54:25, returned true
Running: ValidateMinOSAction at: 2007/6/28 6:54:25
Complete: ValidateMinOSAction at: 2007/6/28 6:54:25, returned true
Running: PerformSCCAction at: 2007/6/28 6:54:25
Complete: PerformSCCAction at: 2007/6/28 6:54:25, returned true
Running: ActivateLoggingAction at: 2007/6/28 6:54:25
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00D5CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3324"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
View 3 Replies
View Related
Nov 18, 2007
I tried to install SQL Server 2005 in a fresh installed Windows 2003 SP2. And this server is a workgroup member, not a member of a domain.
The services (Database service, integration service, reporting services and so on) work fines, but the other components, such as SQL XML 6.0 , SQL Server management Studio cannot be installed. And I have tried several times on a fresh-installed windows 2003 sp2.
I checked the log, I found the following error,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
2007-11-18 15:40:59.35 Server The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
Then the installation existed with the error message "There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. ".
I never had this problem and this time, I really got the trouble and do not have solution.
Who have ever encounter this problem? Or someone can help me?
Thanks.
View 4 Replies
View Related
Jul 22, 2015
I have an intermittent issue where some remote PC's occasionally fail to execute select queries that have a join or return multiple result sets, however simple one table select queries continue to work okay. When it does happen the PC's needs to be rebooted to get to work again. This may only happen some PC's while others continue to work away okay.
I am using a VB6 application and ADO to connect to the database and the error message I get is a General Network Error, Server Not Found when it fails to execute the query. I have ran SQL Profiler on the server and while simple select queries continue to run away okay, a query a join does not even seem to show up in the profiler. The program has been working fine for 15 years with 1000's of users and has only now become an issue on one site for a number of users. Have tried moving the database to a different server and swapping network cards on the local PC's but can't seem to find the cause. The processor and the memory don't seem to be under load, but I am not sure if there is something else in SQL that is causing it to hang under certain conditions.
There have been network analysts experts in to run scans on the network, but I have not had the results of this back yet. Other applications do not seem to be affected so if this analysis does not show up anything.
View 5 Replies
View Related
