Computer Name
Jul 20, 2005If I change the name of my computer/server will it change the name of
my sql instance?
ADVERTISEMENT
How To Know Whether A Computer Is A Sql Server According To The Name Of Computer?
May 9, 2004Thanks a lot
View 6 Replies View RelatedComputer Name
Jun 28, 2006How will I know the computer name of the user in the query analyzer?
View 2 Replies View RelatedComputer Name Could Not Be Obtained
Jun 14, 2006i have stupid problem that had effect my application distripuotion which i think is related either to connection string or something of the security setting of sql server or iis , actually i do not know what to do: the details of the problem is a have multi connection strings in this form :
sqlconnectionPubs = New Data.SqlClient.SqlConnection("Server=SALES-SERVER;Database=NajdiaServiceRequestDta; Asynchronous Processing=true; Integrated Security=True; Trusted_Connection=Yes;")
and the connection works just fine in my computer , even i put the database in the main server and still i can post data from my pc to the main server where my database exist but when i try to post from any other computer in the network it tells me : run time error : computer name could not be obtained.
I appreciat any help
thanks,
How To Transfer DTS From One Computer To Other
Feb 16, 2007How to transfer DTS from one computer to other?
I have a DTS package runing on one server1. I need to transfer this DTS to some other server2. But these two servers are on the different network. Hence temme the way to transfer it to server2.
Thnks,
Rahul
Accessing SQL Through Another Computer
Apr 29, 2008Hello, me and my friend has set up an SQL, I am wondering if it is possible to access the SQL server from my computer when hosted on his.
thanks
Change Computer Name
May 2, 2008I have to change machine name for one of SQL Server 2005 machines. Do I need to do anything on SQL Server as well?
Canada DBA
What's Going On With OSQL On My Computer??
Mar 20, 2008I have not seen this ever on my computer until today...
I start CuteFTP or NetObjects Fusion 8 and I get an installer window popping up saying:
"Please wait while Microsoft configures Microsoft SQL desktop engine"
ZoneAlarm warns me that OSQL.exe is trying to connect to my network.
I let it.
Then ZA warns me that OSQL is trying to connect to the internet.
At this point, if I let it, or deny it, the thing installer (which looks to be half way done) reloads itself and starts over with ZA warning that it's trying to connect locally, then to the internet. Over and over this happens.
It wont let either of my program start until it goes through about 5 or 6 cycles of whatever it's trying to do.
Then it just disappears and my program will load.
If I close either CuteFTP of NetObjects and start them back up, the whole OSQL.exe thing starts again.
I have rebooted and it still does this.
The odd thing is some of the IP addresses it's trying to connect to.
72.14.207.104 - Google
96.6.129.187 - Akamai
207.46.248.249 - Microsoft (ok, that's understandable)
I didn't write the IP address, but it tried to get to Hotwired.com too..
How do I fix this? Why is it doing this?
I'm running XP Pro. P-4 3Ghz 1.5Gb RAM
Thanks for any help!
-Rich
Moving From One Computer To Another
Apr 4, 2006I am developing an SSIS package in a local computer. I have connection managers defined that link to a SQL Server database. I connect to the database using SQL Server Authentication, a username and a password. When I copy the package files and try to execute them in another computer, the password is lost and I have to edit the package and rewrite the password. How can I move a package between computers and not lose the password?
Regards,
Pedro Martins
SQL Sever Computer Name
Feb 26, 2007I don't have any errors to share, but I have a question.
What kind of problems (if any) would I encounter if the computer name where SQL Server 2000 or 2005 was installed included special characters? An example would be FNB_(1).
Best Way To Move CSK Database From One Computer To Another
Jul 21, 2004Hi,
Can someone suggest a good way to move the CSK database from ine instandc of MSDE200 to another on a different PC. I tried exporting using MS Web database administrator which moved the tables but stripped off the defaults and all stored proceedures.
Any better ideas?
Hal
Installing SQL 7 On Computer With Win2000 O/s
Sep 23, 2001Hi Everybody,
I am looking for help on how to proceed. I have only 1 drive that has Win 2000 Prof o/s. I am installing SQL 7. Should I install to the same partition or create a new one for SQL, and are they compatable. I know Win 2k o/s post dates SQL 7. Would SQL 2000 be better? or Win98SE w/SQL 7? The main reason I ask is that I don't want to lose any of the stuff that's on the Win 2k o/s already. Any advice is greatly appreciated. Thanks ! Phil
Renaming The SQL Server Computer Name
Oct 10, 2001Do I have to re-install SQL2000 if I change the Win2000 Server name.
Thanks
SQLservr.exe Taking Over Computer
Aug 25, 2004I have been dealing with an intermittent problem for several months that manifests itself on my computer as well as a customers computer. It is happening so often, upon booting the computer, that I just open and then minimize the Task Manager so that it will be in the Tool Tray and the bargraph will be visible.
From time to time the processor bargraph will "Max out" and when I open Task Manager and click on CPU in the Processes Tab, SQLServr.exe is using 99% of the CPU.
In Enterprise Manager I have set maximum Memory to 25% of the available system memory. I have tried this in both Fixed mode as well as Dynamic mode, no change.
I was told that there was a SQL Server version that was susceptible to a WORM that caused this. I have since upgraded to SQL ver. 8.0.194. I'm not sure of the version that I replaced, but I thought that the previous version was the one that was susceptible to the worm.
Has anyone fought this battle and if so can you offer any experience or advice?
Thanks very much for your help,
Doc
What Should I Do To Connect SQL Server To My Computer (was New To SQL)
Mar 14, 2006I'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 RelatedMoving Database To Another Computer
Dec 2, 2005hi all,
I'm having real trouble trying to place another copy of my database on a different computer.
I have developed a database on my main PC. But I want another copy of this same database to reside on my laptop so that I can do work on the move.
So far no luck. I installed SQL Server on the laptop but it won't let me create a database based on an existing database file.
Any ideas guys?
cheers,
token
Connecting To Sql Server From Another Computer
Mar 25, 2007when 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
I Can't Find Sql Server On My Computer
Feb 4, 2006I 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 RelatedBackup And Restore On Different Computer?
Jul 11, 2006Hi,I use SQL Server 2005. In computer "A", I backup a database "AAA" to afile "AAA_Back.bak". When I try to restore on computer "B", error messageshows up, it try to find the original backup file path in computer "A".How can I fix this problem?ThanksKai
View 2 Replies View RelatedWindows Authentication Of The Computer
Jun 20, 2007Hi
I am using the sql server 2005 windows authentication for connecting my application to the sql server 2005. But somehow i want to create such a login for the database so that any request coming from a particular machine for the database gets fulfilled. Is this possible? If yes please tell me how can i implement this scenario.
Thanks and regards
Salil
I Cannot Install SQL 2005 On My Computer
Jul 17, 2006Hello everybody,
I had installed vs 2005 beta 2 and I wanted to install SQL 2005, so I removed all the components which were installed and were beta edition by control panel and by the tool microsoft supply.
I downloaded sql 2005 but when I wanted to install it, the installation showed me an error that I need to remove all the components that are beta and exited.
The control panel show that there is nothing from vs 2005 beta but the tool try to remove 2 things and has errors. With Everest I see that the components of vs 2005 beta are still in my computer and I cannot remove them.
Someone can help me? I have been searching for an answer for 3 months without any success.
DB Connection On Remote Computer
Oct 19, 2006Hi,
I have installed SQL SERVER 2005 on my network machine.
How do I connect the DB from my machine.
From the Microsoft SQL server DSN CONFIGURATION PAGE on my machine,
I put in the name of my network PC and the SQLEXPRESS .
But connection FAILS.
The Server Name on my Network PC : RCH1SQLEXPRESS
The Full computer name is RCH1
So in my DSN CONFIGURATION PAGE on my machine,
I enetered as RCH1SQLEXPRESS
What am I doing wrong?
Moving My SQL Server To Another Computer
Jul 14, 2006I 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?
Backup On Remote Computer
May 29, 2006
Hi
How can i make backup on the other computer.
1. SQL computer is express edition, and computers are in workgroup?
2. SQL computer is express edition and is not on domain, and backup computer is on domain.
thanks
alex
SQL Login Using A Computer Account
Jun 1, 2006In SQL 2000 I use to be able to grant a computer account access to a SQL DB by adding that computer account to the SQL Logins using DOMAINCOMPUTERNAME$. I have not been able to do this so far in SQL 2005.
Does anyone know if this is still possible or has this functionality been removed from 2005?
Connecting To The SQLEXPRESS On Your Computer
Oct 2, 2006How do I connect to the SQLEXPRESS installed on my computer without network connection (as a standalone computer)?
Thanks.
How To Port A Plugin To Another Computer ?
Jul 10, 2007Good afternoon,
I've developed a clustering plugin for SQL Server 2005 but now I want to port the .dll so my algorithm can run on another machine. Both machines have SQL Server 2005 installed, but different versions of Windows.
What are the steps I need to follow to port the plugin ?
Any help will be very appreciated.
Thanks a lot once more,
-Renan
Copying My Database To Another Offsite Computer
Jul 19, 2006My need: I want to copy my databse (the file itself) in a mem card so that I can use it in another comuter offsite.How do I do that. it s like a back up I think, except that I ll need to import the DB in another computer at home.When I try using Backup the DB of Entreprise Manager, I get violation error, can t copy the file being used or something like that. Am I doing it the right way or is there another better way to do this.
Thanks
Moving The ASPNETDB.MDF File To Another Computer
Jul 22, 2006Hi all!I have some problems with asp.net windows authentication.Asp made the file ASPNETDB.MDF. But I dont have SQL Server on the machine where the application will be deployed...So I have to move this file to another server, but I couldnt find any information about ASPNETDB.MDF connection string or somenthing like this.Is it possible to move this file or I have to make the authentication on my own, with my own database? I hope there is a solution to this problem!Many thanks! Regards!
View 1 Replies View RelatedHow Can I Create New Instance In My Computer Or Any Server ?
Jun 26, 2007If 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 ......
Connection String To SQL Express On Another Computer
Jun 28, 2007I have an XP Pro machine running a classic ASP site in IIS - the version that comes on the XP Pro CD. The site makes a connection to an MSDE database on the same machine named InControl. I have moved that database to SQL Express 2005 and want to test it with the ASP site. SQL Express 2005 is running on a separate Vista machine. I am currently using this connection string:
objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=400SC;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""
Where 400SC is the name of the XP Pro machine and InControl is the database. The variables uid and upass are pulled from Session when the connection string is created.
I have tried different Provider names and various combinations of server name and ip address with and without port numbers for the Data Source. All of them yield some variation of this error:
Microsoft OLE DB Provider for SQL Server (0x80004005)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
What should the connection string look like?
Thanks for the help.
PS - If the solution involves a port, do I need to make that port an exception in the Vista Firewall?
How To Move A SQL Server Database From One Computer To Another.
Jan 8, 2004Currently I'm working on my Desktop computer but I wanna put all my data to my laptop so that I could continue my work on my laptop.
How can I transfer my SQL Server database to my laptop?
How To Send Alert To A Particular Computer From Frontend
Apr 27, 2002hi,
I am using Sql server 7.0.When i insert or update a record in a table,i need to
show a message in the front end ,that one record is added to the table.
I have written the queries for insertion and updation into the table in a storedprocdure.
Is there any way to return something from a storedprodure ,so that i can show a
message in the frontend, that a record is updated by someone..the updation will be
done in one machine(clerk's machine in bank) and the message should be shown in another machine(manger's machine in bank) who has more administrative power on the system.
does 'alert' in sql server help this.
Delphi is my frontend.
help
paul