A server with SQL 2000 installed is moving to a new physical location. Our
company standards mean that the name of the server and the IP address of the
server will change also. This SQL instance name is the same as the server
name. Will I have to uninstall and reinstall SQL Server (and recover the
databases) when this move is made so that the instance name equals the
server name? Is there a stored procedure that changes the instance name to
the server name? Thank you.
We changed the TCP/IP address on on of our BDC's this weekend (also runs SQL 6.5). Now some of our client workstations are not able to connect to the database using TCP/IP. They can connect with named pipes, but it doesn't "stick" on a reboot. It goes back to connecting with tcp/ip. Some of the client workstations can connect with tcp/ip. Could someone help me with this? I'm confused. I can ping the server by name from the workstations and it resolves the tcp/ip address correctly.
I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?
It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).
Hi im trying to save the location of images to a sql server db in the form of a url, i am trying to find out what datatype this comes under here. In ms access u can just select the hyperlink option in the data type dropdown and it saves the address entered into these fields as a hyperlink to the database. How can u do this in sql server ?????
I am asking about a virtual IP for SQL Server, is there a way we can assign a different IP to SQL Server other than the server's(host) IP address? like the same what we do in a clustered env.
I have not been able to find any substantive documentation on connecting a DataSource to the database via the IP address of the SQL Server. Does anyone know of a good reference on the topic? I want to be able to access the data on the server while developing and testing locally on my laptop (not on the same network).
We have a SQL Server 7.0 SP1 NT 4 SP5 that has 40 or so clients connecting to it via a software package using NT Authentication. It was noticed that in Enterprise MGR, in Current activity panel under Network Address that all 40 or so clients do not show there individual MAC address, there are 3 different addresses, one does appear to be a client that is repeated for several other clients, one appears to be a network hub and the third one we have not determined what it is. These are all WIN 95 clients. When we use NT Workstation to connect to this SQL Server with Query Analyzer it does show the correct MAC address. Any ideas on what is wrong or where to start? Any help would be appreciated! Thanks
I'm working with a small ISP/Hosting company and we set up a development server with NT, Site Server, SQL 6.5, and Site Site Commerce Edition. It has been working fine, but the other night their network guy assigned a new IP address to the NT server.
Now SQL server can't talk to/find the NT server. Any time you try to look at anything in Enterprise Manager, it throws the error:
DBLibrary - Server is unavailable or does not exist...general network error.
We can't figure out how/where to tell SQL Server that NT has a new IP address, and get it all working again.
I wasn't able to connect to my SQL server 2000 database (which reside in the network in a windows 2003 server) after the IP address of the server has changed and the server is shut down, moved and re-started.
I was able to connect to this server by using ADO using VB. I was able to register this server in my EM and was able to create ODBC connection. Just when using ADO.NET, I wasn't able to connect. Any ideas? Will there be any caching within ADO.NET still pointing to the old IP address?
How I can register MSSQL Server 2000 by IP Address-
I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. It’s primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.
I would like to registration of sqlserver instance by IP Address. How I can do it.
we have a server (Windows server 2008 R2 Standard) that runs a hyper V manager.The Hyper V manager runs 2 virtual servers.
One of the virtual servers uses the software XAMPP (it’s a web portal). The local IP for the virtual machine is 192.168.0.xxx
I have configured the XAMPP in a way so that any user in our domain can access the portal when the user writes the ip address in the web browser.Instead of the ip address, I want the user to be able to write a specific given name.
can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also.
When i am trying to configure Mirroring .i am getting the below error.
The server network address "TCP://RDEEPA:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
. TCP/IP and Name pipe connection is enabled in both principle and mirror server configuration.
I post the complete error message below ,which is in red
TITLE: Database Properties ------------------------------ An error occurred while starting mirroring. ------------------------------ ADDITIONAL INFORMATION: Alter failed for Database 'success'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476 ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------
The server network address "TCP://RDEEPA:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------
Hi all, I'd like to link a SQL Server database / table to Microsoft Exchange Server E-Mail-Address data, for an Employee Directory project.
I've read a little about "Web Store", a little about ExOLEDB, but I've come across nothing along practical lines. I.e., I still don't know where to begin!
For example the "Web Store" should be created on the SQL server, but how do you create it? Any insights will be greatly appreciated.
IF you need to change the IP Address of a SQL Server Failover Cluster instance, here is the steps:
1. Open up Failover Cluster manager. 2. Expand the MS Cluster Instance that your SQL Cluster instance resides on. 3. Expand Services and applications. 4. Select the SQL Server Service. 5. In the main window pane (Middle Screen), you should see your SQL Server Cluster name, expand the plus to the left of it. 6. Under your SQL Server Cluster name, you should now see an 'IP address' section, right click on it and go to properties. 7. In the properties pane, you can change your IP address by entering a static IP.....or assigning a DHCP enabled IP.
While I try to configure replication getting below error message:SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, "servername". (Replication.Utilities)
Note: SQL server instance names shows different in sql server configuration manager and SSMS sql server instance name in  configuration manager: 2di3100sqlserverprod ,but i run the query in SSMS SELECT @@SERVERNAME it shows: 2di3100plugin.
I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is
The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)
Please let me know what all I need to do to resolve the problem.
I have noticed in the database logs that someone is trying to log into our SQL Server express databases, is there a way of allowing only IP address on a list to access the database. We really only need the local machine and the office using SQL Express management studio to access the database.
I would appreciate any help sometimes the database runs very slow and we do not know what is causing this.
We are running server 2003 and SQL Server express.
We have a bought in application written in Visual Basic 6 using ADO 2.7 to connect to SQL Server. The application has two connections strings and uses internal logic to determine which of the two connection strings connects to a read-write database. It does something as simple as trying an update that makes no changes to a very small table somewhere.
Previously this application connected to a Mirrored Database hosted on two Windows Server Failover Clusters and SQL Server 2005.For the future the App will be connecting this application to a SQL Server 2014 Availability Group.The Availability Group is made up of four servers, in a cluster, two at one site on Subnet A and the other two at a second site on Subnet B. The Availability Group has been given a Listener with a DNS name of AGLISTEST on port 1433 with two Static IP addresses, one for each subnet.
Our Contractor has configured the Application’s connection strings to connect to the two Static IP addresses assigned to the AG. He is of the opinion that although ADO has zero understanding of an Availability Group, at least one of the Static IP Address will translate to the Availability Group primary server because it is a Cluster Resource and so act like a Cluster IP Address on Windows Server Failover Cluster; i.e. sort of mimicking the previous configuration. This does work and he has demonstrated it, however I can’t find any article that proves to my satisfaction this is intended behavior not something that accidentally works. If it is accidental behavior then that would be something that might stop working at an unexpected point in the future.
All the research I have found relates to connecting to the AG Listener name, and all the multi-subnet issues and Active Directory issues that go with connecting using what is a legacy client.So; the question is, is this translation / redirection of static IP Addresses assigned to an Availability Group listener documented and safe?
I'M HAVING AN ISSUE, UNDERSTANDING, THE CONNECTION STRING. I WANT TO CONNECT TO AN INSTANCE OF SQLEXPRESS ON A REMOTE SERVER WITH A FIXED IP ADDRESS THE TCP PORT IS OPEN TO 1433 I OPENED THE PORT ON THE ROUTER AND THE WINDOWS 2003 FIREWALL
MY CODE IS AS FOLLOWS: S = "Provider=SQLNCLI;" S = S & "DATA SOURCE=44.66.777.888,1433SQLEXPRESS;" S = S & "INITIAL CATALOG=TESTDB;" S = S & "Persist Security Info=false;" S = S & "UID=TEST999;" S = S & "Pwd="TEST999888;" CnMgt.ConnectionString = S CnMgt.Open S
I'VE FOLLOWED THE STEPS OUTLINED IN ARTICLE 914277
CAN SOMEONE HELP? THANK YOU
PS. IF THE CLIENT IS LOCAL, I HAVE NO ISSUE OPENING THE DATABASE. I DO NEED TO OPEN THE DB FROM FROM CLIENTS.
