Hi,
I have system with SQL Server 2K5 SE 3042 SP2 . I was able to set up mirroring with primary-mirror-witness arrangement through GUI.
In this company I replaced another DBA who left, and the way our sys admin arranged our logins co-existed in domain for a while. Then sys admin, after mirroring was done, removed my login, renamed other DBA's login with mine, and removed his.
Now I cannot create endpoint, either by t-sql or through GUI: "An implicit login creation has failed. Reason: the login may have been dropped or its name may already be in use, error 1545".
After pressing Start Mirroring the following shows: "Database Mirroring Transport is disabled in the endpoint configuratin, error 1486". The 2nd error understandable in view of the 1st one.
I checked sys.database_mirroring_endpoints, it is empty. Anyone has an idea what this implicit login is, and where to look for it?
The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration?
Msg 7878, Level 16, State 1, Line 3
This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.
I have been looking at this statement for allowing access from a remote location to a specific database on my SQL Server (2005) from a client application. Is it possible to do this using this method? I see lots of examples using this to expose Web Services of DB objects, however I need the client application to be able to authenticate to and access all objects in the database. If so, could some one provide a simple example of the arguments to use? For example, which protocol arguments are valid for this? I would like to use SQL Server Authentication. Is this possible? Regards, -Troy
Just installed VS 2005 & SQLServer 2005 clients on my workstation. When trying to create a new Integration Services Project and start work in the designer receive the MICROSOFT VISUAL STUDIO 'Object reference not set to an instance of an object.' dialog box with message "Creating project 'Integration Services project1'...project creation failed."
Previously I had SQLServer 2000 client with the little VS tool that came with it installed. Uninstalled these prior to installing the 2005 tools (VS and SQLServer).
I'm not finding any information on corrective action for this error.
what can cause the above error when connecting to an endpoint via a c# app? the app, and sql are both on my machine ( im just doing this for test purposes and to learn something new.)
I already had a thread for same problem but didn't recieved any response in last 4-5 months so I created a new thread for this
I am using service broker in between two database servers. following is the way i am sending and receiving messages
Send
BEGIN TRAN BEGIN DIALOG CONVERSATION @handle FROM SERVICE @SendService TO SERVICE @ReceiveService ON CONTRACT @Contract WITH LIFETIME = @lifetime;
SEND ON CONVERSATION @handle MESSAGE TYPE @xmlMessageType(@xmlMessage); COMMIT
Receive
BEGIN TRAN; RECEIVE TOP(1) @xmlMessage = message_body, @handle = conversation_handle, @message_type = message_type_name FROM TransactionQueue;
---------------------------------------------------------------------------------------------------- -- Check to make sure a message was returned to process. In theory this should never happen. ---------------------------------------------------------------------------------------------------- IF @@rowcount = 1 BEGIN
IF @message_type = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' BEGIN END CONVERSATION @handle; COMMIT RETURN 0 END
IF @message_type = N'http://schemas.microsoft.com/SQL/ServiceBroker/Error' BEGIN RAISERROR(N'Received error %s from service [Target]', 10, 1) END CONVERSATION @handle; COMMIT RETURN 0 END
SET @sql = 'EXEC '+@message_processor_name+' @xml'
BEGIN TRAN EXEC sp_executesql @sql, N'@xml XML', @xml=@xmlMessage COMMIT TRAN END CONVERSATION @handle; END COMMIT
I see Messages are delivered to the target every thing working fine other than following errors which i am seeing in profiler.
1) "This message could not be delivered because the conversation endpoint has already been closed." I see this error on initiator end. Is it like ending conversation on initiator end when i get "EndDialog" send an acknowledgement, which cannot be recieved by target as it has already ended conversation.
2) "An error occurred while receiving data: '64(The specified network name is no longer available.)'." I don't have much idea about the reason for this error. But in profiler i see value for GUID is different for this error and the real message.
I am getting the following error when creating a endpoint (that will be used for allwayson) The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.
My physical network card is configured with:
10.9.255.170
and iam creating my endpoint with 10.9.255.82
The creation of endpoint is being done with;
CREATE ENDPOINT [Hadr_endpoint] AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (10.9.255.82) FOR DATA_MIRRORING (ROLE = ALL, ENCRYPTION = REQUIRED ALGORITHM AES) GO IF (SELECT state FROM sys.endpoints WHERE name = N'Hadr_endpoint') <> 0 BEGIN ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED END GO use [master] GO GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [account] GO
I am trying to create an asymetric key in order to set up my CLR trigger for external use but it fails.
As soon as I get this to work I plan on creating a login from this asymetric key and then grant External Access to the login. But first When I execute the following T-SQL code, I get the subsequent error. Can someone help?
USE master GO
CREATE ASYMMETRIC KEY SQLCLRKey FROM EXECUTABLE FILE = '...ExceptionLogTrigger.dll'
The certificate, asymmetric key, or private key file does not exist or has invalid format.
Assuming all windows servers belonging to the WSFC are on the same subnet, will the AG listener become a single failure point in system if all Application servers connect to the AG through the listener? If the answer is yes, what are the options to resolve this issue?
I'm trying to get my first replication going, and I have set up a database successfully, along with merge replication, however when I attempt to create the first subscriber, I get a permissions issue, regardless of what I do. In the SQLCESA30.LOG file, I get the following entries:
I posted the initial thread under the "Replication" forum, but am including this 'pointer' post here due to a lack of replies there, and the relevance of this thread to this forum. Please see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for more details.
I am fed up of getting the below error message of repl. atleast once a day.
JOB RUN: 'REPL:1001' was run on 3/23/2007 at 3:00:01 AM DURATION: 1 hours, 11 minutes, 11 seconds STATUS: Failed MESSAGES: The job failed. The Job was invoked by Schedule 421 (Replication agent schedule.). The last step to run was step 3 (Detect nonlogged agent shutdown.).
Please see below for the description of my Replication Job: ------------------------------------ Steps of Job: 1. Distribution Agent startup message. db: distribution cmd: sp_MSadd_distribution_history @perfmon_increment = 0, @agent_id = 126, @runstatus = 1, @comments = 'Starting agent.' 2. Run agent. cmd: -Subscriber [GIZMO] -SubscriberDB [TelehopBilling] -Publisher [ROGER] -Distributor [ROGER] -DistributorSecurityMode 1 -PublisherDB [TelehopBilling] 3. Detect nonlogged agent shutdown. db: distribution cmd: sp_MSdetect_nonlogged_shutdown @subsystem = 'Distribution', @agent_id = 126
This Job is executed every hourly and an error is fired atleast once a day notifying failure of this process. Please help me in resolving this issue.
I have an ASP page I'm testing and this is what I'm trying to do with it. I simply need it to read a SQL table on my server and display data from that table on screen. Thats it. But no matter how many times I tweak my code I keep getting 404 web page not found. Here is the entire pages code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN" <script language="JavaScript"> <!-- var win = null; function NewWindow(mypage,myname,w,h,scroll){ LeftPosition = (screen.width) ? (screen.width-w)/2 : 0; TopPosition = (screen.height) ? (screen.height-h)/2 : 0; settings = 'height='+h+',width='+w+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',resizable=no' win = window.open(mypage,myname,settings) } //--> </script> </head>
<% '************************************************************************** ' This page will be used as a test page for Guests and Links ' its purpose is to simply read the guests and links tables then show ' what ever data is in them on the asp page. '**************************************************************************
' This is the SQL section <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" con.Open "PROVIDER=SQLOLEDB;DATA Source=IP Address of server here;Initial Catalog=folder name here;User ID=sa;Password=password here"
set rs = Server.CreateObject("ADODB.recordset") sql="SELECT * FROM T_ProgramGuests WHERE GuestID > 1" rs.Open sql, conn %>
<table border="1" width="100%"> <tr> <%for each x in rs.Fields response.write("<th>" & x.name & "</th>") next%> </tr> <%do until rs.EOF%> <tr> <%for each x in rs.Fields%> <td><%Response.Write(x.value)%></td> <%next rs.MoveNext%> </tr> <%loop rs.close conn.close%> </table>
Your reputation follows you, even into cyberspace. Online reviews, peer comments and user opinions are changing the way we decide to trust other people. Technology reporter John Doe sees current website ratings leading the way to a new standard of social acceptance.</p> </body> </html>
I'm doing something wrong here but I'm not sure exactly what I'm missing. Is my SQL connection statement wrong? Or is it a syntax issue? Any suggestions?
Hi Y'all, When i alter 1 single value in my sql server 2000 sometimes i get following error: 1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure After clicking away: 2)CANNOT START MORE TRANSACTION ON THIS SESSION Maybe someone can help me out on this? Thanks!
But it gets through the install, then the progress bar goes backwards and it uninstalled, I tried to enable logging and do /q+ but none of this gives usable information, i have redownloaded the MSDE SP3 install files and this has changed nothing, I know this is a common problem as I have seen a few sites mention it, but i can't seem to find the fix.
I am running transactional replication between a pair of SQL Server 2005 machines using a remote distributor. Occasionally the log reader agent fails with the error
"Replication-Replication Transaction-Log Reader Subsystem: agent * failed. The process could not execute 'sp_MSpub_adjust_identity' on '*'."
The agent starts back up again almost immediately on its own with seemingly no problems. I haven't been able to find any documentation on this error from Microsoft. Any ideas?
It is not a permissions issue as the log reader agent (and all of the other agents at that) are running under windows accounts with domain admin access for the domain that both the publisher and the distributor SQL Servers are on. (I know, I know, that's horrible. I've only been here a week and a half and I just found out about this today, so I didn't have anything to do with such a glaring security issue.) All of the SQL Servers involved with the replication are still granting sysadmin access to the windows administrators group.
I have not been able to find any details about backup failures forMSSQL 2000. I am researching the following:1. when a backup fails at a certain point during the process does thebackup:A. stop there having recorded some details?B. quit without backing up any of the data it already processed?C. skip the data it cannot read and move on?2. Does the error log record any of the details above? For instance, ifthere is a table that the backup could not write to .bak, does theerror log report exactly where the error was?I need a way to obtain a Backup Exception 'Report' that when a backupfails it can tell me what did not get into the .bak file. I wouldprefer automatic notification. Our Oracle DBs have something setupthat can be run when a piece of the DB does not get backed up lettingthe Oracle DBA know where there are issues.Thank you,Stephanie
I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:
1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network
2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:
[Microsoft][ODBC SQL Server Driver]Communication Link failure
This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.
Overview. I am converting over from MSDE to SQL Express. My front end program is unable to connect to the database. To troubleshoot, from the remote computer I tried connecting with the management program and I get the Error 26 unable to connect.
(The connection string worked previously (yesterday) when using MSDE as the server. When I installed SQL Express I named it the same instance as the server name under MSDE. I also use server authtication on both with same user name and password. As stated below I cannot connect using the managment console.)
Here is what I have done: I made sure that the SQL Server configuration has been changed to allow network connections (both TCP and named pipes). I have disable windows firewall on both machines. I confirmed that I can connect from the remote machined to the server by network browsing. Both machines are running XP Proff. There is no other security software running on either machine.
More Info. when attempting to log on I am using the server authntication, I use "sa" as the user id plus my password.
Goal. The front end of database program connects to the server remotely using a program called Hamachi over the internet. This works without a problem on MSDE. But for now I am simply try to connect using the managment program which lets you browse for other serves. When I do this it shows the remote computer, but not the name of the computer but not the SQL server which I type in like the following: "INTELsql1"
What I have not Done: I have not changed any permissions or added any users to the server, since this does not seem necessary. As stated the user of remote machine can connect to the server and change files.
Would appreciate any suggestions or tips. Thanks. I HAVE READ THE POST FROM MAY 13, 2007 AND TAKEN ALL STEPS SUGGESTED EXCEPT MAKING SURE THE BROWSERS SERVICE IS RUNNING ON SERVER WHICH I WILL DO NOW.
I have started to see regular occurences of "ODBC error 40001- serialization failure" in the log of a client website (using cold fusion) and would be grateful for any suggestions on likely causes and solutions. The error message also mentions deadlock victims. Thank you in advance.
Have a problem with SQL today. I rebooted the server and now it cannot see the E: drive, as per the RAID array setup. Problem being is that all my SQL databases and logs are on this drive. I'm guessing that the error message is just misleading as based on Microsoft this means the server is stand alone and needs to be started with a non-Domain account. Fix the hardware RAID array and hope all is well. Does that sound about right to you?
I'm looping through a set of IP's (sql servers), i'm changing the property ServerName for OLE DB connection dynamically.
So, I'm having a DataFlow Task inside a For each Task.
Data Flow task has OLE DB Source & OLE DB Destination. I've set ServerName of OLE DB Source to a variable which gets updated by For Each Loop.
Till now everything is working fine. However, if a Server (IP) is down it causes OLEDB Source to give an error. So in my case, if one server is down, it gives error and does not proceed further. I want it to continue with other servers.
24.121.0.118, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322), ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Any ideas? Would setting the isolation level to Read Commited help?
This is regarding the intermittent failure of communication between the application server and database server in one of our customer environment. Application error as well as SQL error log shows "General Network Error","Communication Link Failure". Please find below the server configuration
Application Server OS: Win 2003 server + Service Pack1, Standard Edition Database Server OS: Win 2003 server + Service Pack1, MS SQL Server 2000 + SP4
We have checked the Client/Server Network utility associated with SQL Server and found TCP/IP protocol is used in communication neither than Named Pipes. DSN is used. We have also followed and implemented as per one KB article which mentioned Win 2003 server's feature of preventing Denial of Service attacks (Chance may be there to prevent the valid login packets).We made the registry changes and disabled this feature. A scheduled job which updates the database happens every morning. Also backup was done using a backup utility which needs the exclusive access to DB. So we have asked the customer to use enterprise manager for back up the DB instead of using the other utility to backup. If any one have experienced the same issue, please let me know.
I've a computer with W2K SP4 installed. Previously SQL Express 2005 worked but according to the user it "just stopped working".
When selecting database on the server in the "Data Link Properties"-window he is given the following error message:
"Microsoft Data Link" "Login failed. Catalog information cannot be retrieved" followed by "Microsoft Data Link Error" "Connection failure" Note: He is not given the error message "Server does not exist or access denied!"
- The SQL service is started (can be stopped and restarted without problem) - I've re-installed SQL Express. - I've checked and is certain the server name is correct (i.e. computernameSQLEXPRESS)
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect sqlstate=01000, level=-1, state=-1, native_error=444, msg=The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'. sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.
SQL_ERROR (-1) in OdbcConnectionHandle::set_attr sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcConnectionHandle::get_attr sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcHandle::release sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
SQL_ERROR (-1) in OdbcHandle::release sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
Error Code: 0x8007ea74 (60020) Windows Error Text: Source File Name: libodbc_handle.h Compiler Timestamp: Wed Oct 26 16:37:41 2005 Function Name: OdbcConnectionHandle::set_attr@connect Source Line Number: 168
Connecting to SQL Server ExecuteSqlCommands Originial error was 8007ea74 (60020) ipt SqlScriptHlpr
Error Code: 60020 MSI (s) (D0!0C) [18:24:47:187]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][ODBC Driver Manager] Driver does not support this function. Refer to the server error logs and Setup logs for detailed error information.
Using BULK Insert with a format file I am receiving the following message:
Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'STREAMS' reported an error. The provider did not give any information about the error. The statement has been terminated.
I am running SQL Server 7.0 w/ SP1 applied. The same data file and format files work fine if I use bcp.