Renamed Computer And Connected To Sql Server Without Problem...
Sep 5, 2005
I have read that if I change "computer name" and then try to startup sql server it will recognize the changes automatically BUT you need to execute sp_dropserver and sp_addserver procedures too in order to set all thing right.But yesterday I tried it on a Personal edition on xp and after reboot sql server came up without any problem and I could connec it without executing sp_dropserver and sp_addserver! Was it a specific situation or no need to those SPs at all?
View 10 Replies
ADVERTISEMENT
May 1, 2008
Hi Guys
I have sort of a weird problem; we havea sql server 2000 box which was virtualized using VMWare, the virtual server was then renamed and used as another sql server.
there is a simple .net framework 3.5 console application (running on the same sql server box) that reads and deletes data from that sql server, this console application opens 2 connections simultaneously, for some reason after creating the VM and renaming the server this app didn't work, the problem is that when there was one connection open the second connection command always times out though the command only deletes one record from the DB.
After several trials I found that if I ran this app from another server it works without problems and to get it working on the same box as the sql server I have to use the ip address instead of the server name in the connection string.
I had another problem related to editing the sql agent jobs on the renamed server but I found a solution for this one in KB article.
Any ideas?
View 6 Replies
View Related
Mar 3, 2008
Had to migrate to new hardware running Server 2003, sql 2005. Databases, logins, two SSIS(DTS) packages working great. But, System and User maintenance plans failing since name change.
So, recreated them, and (with minor problem to be addressed at another time) the recreations are working fine. But, I can't delete (or modify) the old plans or jobs. Get the following error when physically sitting in front of the server logging in "Exception has been thrown by the target of an invocation(mscorlib). An error has occurred while establishing a connection to the server. When connecting to sql server 2005, this failure may be cause by the fact that under the default settings, sql server does not allow remote connecitons. (provider: tcp provider, error: 0 no such host is know) error 11001
As I said, I've disabled both jobs, but would prefer to delete the plan/jobs. But, it won't let me. Any ideas?
View 2 Replies
View Related
May 9, 2004
Thanks a lot
View 6 Replies
View Related
Mar 23, 1999
When I try to connect to my SQL server I get the following error.
Microsoft SQL Enterprise Manager
A connection could not be established to MLM1-[SQL Server] Cant allocate space for object 'Syslogs' in database 'tempdb' because the 'logsegment' segment is full. If you ran space in syslogs dump the transaction log. Otherwise use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
Ok, I am not up on SQL so I'm not sure how to dump my tempdb database. I have a coworker that has only done this sort of thing in the Enterprise Manager and we can't get there. So how do I do this and make sure that I don't blow away any data? Also if I do dump my tempdb will this cure my problems and how do I avoid having this happen again?
Any help would be greatly appreciated,
Jeb
View 1 Replies
View Related
Jan 7, 2006
using vs2005 to build web pages of asp.net 2.0, The database is SQL Server 2000,.But I always fail to connect.
using the following configuration in web.config:
<appSettings> <add key="DSN_student" value="server=(local);uid=admin;pwd=123456;database=network_course"/> </appSettings>
I also failed to connect using the following configuration in web.config:
<add name="network_courseConnectionString1" connectionString="Data Source=(local);Initial Catalog=network_course;User ID=admin;Password=123456;" providerName="System.Data.SqlClient" />
I am a beginner from China and eager to get answers! Thank you!
View 2 Replies
View Related
Apr 9, 2008
We have renamed the 'sa' account on a SQL Server 2005 machine. Whenwe runSELECT * FROM sysloginsit appears that 'sa' no longer exists as a valid SQL login. However,when we look at running processes through sp_who, we see that 'sa' isstill being used in various background operations, even when we shutdown and restart the SQL Server. Can someone explain this?Bill E.Hollywood, FL
View 2 Replies
View Related
Oct 30, 2007
Hi
I have created a database using the following create database instruction
Create Database SoftwareChange
ON (NAME = 'SoftwareChange',
FILENAME = 'C:DevelopmentSoftwareChangeDatabaseSoftwareChange.mdf',
size = 10mb,
filegrowth = 2mb)
log on (NAME = 'SoftwareChangeLog',
FILENAME = 'C:DevelopmentSoftwareChangeDatabaseSoftwareChangeLog.ldf',
size = 2mb,
filegrowth = 1mb)
go
This shows up fine in Managment Studio, I then connect to the database from VB.net Express and it connects to the database using the following connection string :
Data Source=.SQLEXPRESS;AttachDbFilename=C:DevelopmentSoftwareChangeDatabaseSoftwareChange.mdf;Initial Catalog=C:DevelopmentSoftwareChangeDatabase;Integrated Security=True;Connect Timeout=30;User Instance=False
I don't want it to be a user instance as and without the path in AttachDBfilename it doesn't see the database.
Here's the problem when I go back into Management Studio and click on the SoftwareChange entry under databases it gives me a file not found error then subsequently doesn't let me open it. However another database entry has appeared "C:DevelopmentSoftwareChangeDatabase", this is the path of the database and displays the contents of SoftwareChange. I can detach and re-attach as SoftwareChange but why does VB.net (i assume) change the name of Db in SQL.
Regards
Ian
View 3 Replies
View Related
Sep 29, 2007
I recently changed the name of my pc to MYNEWPC ...but in SQL Server 2005 Security/Logins there are a couple of logins pointing to the old name...would i need to add these, change these or do something to make it point to the new pc name?
Here is what I see that needs to be changed from MYOLDPC to MYNEWPC, how do i go about doing this..is this needed?
MYOLDPCSQLServer2005SQLAgentUser$MYOLDPC$MSSQLSERVER
MYOLDPCSQLServer2005MSSQLUser$MYOLDPC$MSSQLSERVER
MYOLDPCSQLServer2005MSFTEUser$MYOLDPC$MSSQLSERVER
View 1 Replies
View Related
Jan 18, 2008
I have uploaded my site on localhost and sharing on intranethow can i answer these question? Q1) How many users have loggedin? and using my database?Q2) Which table has lots of load?Q3) how can i immediately close particularly connection?
View 4 Replies
View Related
Dec 8, 2005
Hi !
I need to maintain a record such as how many time any user (e.g, sa) connects to the sql server. Means whenever any person is connecting to the database through application or directly, then i need to know that through which sql user(e.g sa), any body connected.
Regards,
Shabber Abbas Rizvi.
View 1 Replies
View Related
Jul 20, 2005
Is there a utility that will allow me to see what users on my network areconnected/active on SQL server?Ryan
View 4 Replies
View Related
Jul 27, 2006
I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN.
Following are what I gave as IP address and DNS on the server:
IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank
On the client, I have,
IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank
I can ping and connect to either of the machines.
If I do a sqlcmd -S "tcp:servernameINSTANCE,port", I get the following error message:
HResult 0x80090304, Level 16, State 1
SQL Network Interfaces: The Local Security Authority cannot be contacted
Sqlcmd: Error: Microsoft SQL Native Client : Cannot generate SSPI context
If I do a sqlcmd -S "tcp:192.168.16.2INSTANCE,port", it connects to SQL Server.
I have the Windows Firewall ON. If I Off the firewall, I do not have any problem at all.
I included File and Printer Sharing, sqlsvr.exe in the Exception list of the Windows Firewall.
Any help to solve the issue is appreciated.
Thanks.
View 7 Replies
View Related
Sep 19, 2000
Our network people changed our machine name one character without our permission, they say their naming standards can't handle an "underscore" we put in our name...now the SQL Server won't run because it doesn't recognize the name of the machine.
Is there a way of bypassing or telling SQL server that we changed the name without having to reload all of our information?
View 2 Replies
View Related
Sep 16, 2015
I have a query that finds all SPID's connected to a particular database:
select d.name, p.*
from sys.databases d join sys.sysprocesses p
on d.database_id = p.dbid
where d.name = 'my_db'
But now we have a new rule that we should not use outdated compatibility views, and one of them is sys.sysprocesses. I checked sys.dm_exec_connections/session/requests but failed to replace my existing code. The first two don't have dbid, the last one, requests, has it, but it selects only currently executing statements.
View 0 Replies
View Related
Apr 16, 2008
Here's the scenario -
We had issues with our production database which had 'broker enabled', I restored an older backup and then renamed the Prod database to ProdOld and the Backup database to Prod. We noticed yesterday that the broker service wasn't working and had the error
'The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.
'
I ran the following script against the database
ALTER DATABASE prod SET ENABLE_BROKER
go
GRANT CREATE PROCEDURE to User
GRANT CREATE QUEUE to User
GRANT CREATE SERVICE to User
GRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] to User
GRANT VIEW DEFINITION to User
And it came back with a message that the broker was already enabled.
I did a disable/enable just for kicks, but we still get the same error message.
I did a check on the sys.databases table and it shows that the 'is_broker_enabled' field set = 0 (should be one)
Any ideas on what's going on here? Could the rename caused the broker to become out of sync?
It would be great if I could just update the bit field, but I don't believe there is an easy way of updatting the system tables.
Thanks in advance
View 3 Replies
View Related
Feb 25, 2015
Recently I needed to find all processes connected to a particular database, let's call it Test_db. I have a simple query to find all connections to my database:
select *
from sys.databases d join sys.sysprocesses p
on d.database_id = p.dbid
where d.name = 'test_db'
But there was a process that was connected to another database like USE another_db_name; but was actually selecting from tables in test_db. Is it possible to catch such connections?
View 7 Replies
View Related
Jul 20, 2005
Hi,i have a problem about the CLIENT-SERVER architecture procedure.Well , i have an application in VB with ADO connection to a table in adatabase on a SQLSERVER 7.0 .Is possible to do that when a client updates a data in a field of my table ,the SERVER communicates to all clients connected to my table that this dataare updated , without the client do anything , for example without aclient-timer to control the data in the server ???thanks
View 2 Replies
View Related
Mar 18, 2008
We have an information retrieval application in which there is a single connection to a database followed by multiple table open, read, and close commands. Response time is consistantly less than 1 second on a LAN.
When Internet connected (not VPN), the first table read is typically fast, but the response time becomes slower and slower after multiple table open, read, and close commands. There seems to be a considerable amount of handshaking based on monitoring of the router's status lights.
View 7 Replies
View Related
Apr 17, 2014
I had a cluster running on 3 nodes (windows failover cluster) with server 2012 and SQL server 2012 running in the cluster. Well, I thought I'd just go ahead and rename all 3 of the hosts with new hostnames and it apparently broke the cluster pretty bad. Now when I open failover cluster manager I cannot see anything nor can I connect to the cluster object in AD. I re-named all of the hosts back to their original names but that didn't work.
View 5 Replies
View Related
Apr 1, 2015
I am using SQL 2012 SE and implementing transactional replication. I need to insert the rows from publisher database tables to new tables, drop the old tables and rename the new tables with the old table names.
For example:
Publisher database tables that are being replicated:
Table1
Table2
Table3
and I am going to create new tables in publisher database
Table1_new
Table2_new
Table3_new
Move data from
Table1--->Table1_new
Table2--->Table2_new
Table3--->Table3_new
Drop constraints from and then tables (does this require articles to be removed from replication?)
Table1
Table2
Table3
Rename
Table1_new to Table1
Table2_new to Table2
Table3_new to Table3
Does this require replication to set up from scratch or add the three articles only to replication? Is there a way this can be done without pausing or reinitializing replication or without removing articles and adding them back?
View 0 Replies
View Related
Jun 2, 2004
Hello all,
When I close a web form that has a connection to my SQL Server, I am not seeing the memory process close in task manager (of the SQL Server). I am using the "open late close early" theory of database connections. I am using the "close" method for my database connections. Is there any automated utility that will shut down these processes? I thought when the user was disconnected from the database, the memory process would automatically shut down.
Any suggestions, thoughts, or ideas?
TYIA,
lonelobo
View 1 Replies
View Related
Jan 5, 2007
I have a website I'm ready to test on the server it will call home. I just got connected to the remote SQL server that it will be using. As I've been creating the site, I've been using the default SQL Express set-up in Visual Studio. Is there a way to have Visual Studio create all those default tables, procedures, etc. OR is there a way to copy all of that stuff from the SQL Express running on my machine to the remote SQL Server 2005?
-Mathminded
View 4 Replies
View Related
Jan 16, 2007
Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?
I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.
Any ideas?
View 5 Replies
View Related
Oct 16, 2007
Does anyone know if this is a SQL Native Client bug? I've read a previous thread (posted back on Jan. 18th, 2007) about this error, but there are no replies. I am getting this error when I issue the sp_setapprole command using sqlexecdirect() ODBC api call. Is there any way to work around this? Or is there a fix to the SQL Native Client? The error 15002 message text states "The procedure sys.sp_setapprole cannot be executed within a transaction". This is on a new connection so there should be no transactions active at the time. Thanks in advance for any info anyone can provide on this.
View 5 Replies
View Related
Oct 10, 2001
Do I have to re-install SQL2000 if I change the Win2000 Server name.
Thanks
View 2 Replies
View Related
Mar 14, 2006
I'm new to programing things, i'm on my own with MCAD/MCSD Amid Calani, i came to the point were i can"t go any further: i have VS enteprise architect,but i have only instece of SQL server,recently i downloaded SQLExpress , what should i do to connect SQL server to my computer, just because i'm new to to it looks stupid but maybe someone can HELP me with this. HELP, HEL,SOS,SOS...:eek:
View 14 Replies
View Related
Mar 25, 2007
when i connect to sql from the same machine i use
mserver="newserverSQLEXPRESS"
what would i use connecting from another machine
i tried the ipaddressSQLEXPRESS
and if didn't work
View 3 Replies
View Related
Feb 4, 2006
I installed sql server on my PC, and when I look at the Programs I dofind sql server, but when I click on that I get "configuration tools".I don't see anything that says "enterprise manager" for instance. Howcan I find it so I can make a shortcut to it?Thanks
View 4 Replies
View Related
Jul 14, 2006
I will moving my SQL Server to another server. The plan is to stop SQL Server copy database file to a temp netwokr location, Switch off this server. Configure the new server with the same name and IP, install SQL to the same paths and service pack to the same level (SQL 2000 sp3). Then start and stop the SQL server. Once stop I will then copy the old database file over the new ones.
I know in general this works as I have doen this many times before expect this time round there is a replicaiton database which is new, I am expecting this will work the same but has any one else tried this before?
View 1 Replies
View Related
Dec 27, 2007
Hi All
I have Computer is setuped SQL Server 2000 and SQL server 2005 when I restore SQL Server 2005 it's OK but when it's not OK when I restore in SQL Server 2000. The Error as follows:
Please help me to solve this problem. Thanks
View 1 Replies
View Related
Dec 18, 2007
Hi,
Is there a way in SQL Server 2005 to use a select statement to fetch data from a table in another Server while running the query in one Server.
Like using a database Server Link in oracle...
Thanks
Pramod
View 8 Replies
View Related
Jun 26, 2007
If there is one instance in a server and I would like to create another instance, what should I do ?????
Or if my computer is not included any instance, How can I create new instance on my computer ?
????
Please give me any suggestions ......
View 1 Replies
View Related
