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
ADVERTISEMENT
Accessing Script File On Local Computer
Apr 13, 2004I am trying to create a sproc creates several tables, views, and sprocs across several similar DBs (please...no lectures on structure...I didn't create this multi-DB setup) .
My sproc loops through the DBs and runs a script on each DB. I am running the Sproc from a client computer and cannot easily access the c drive on the SQL server.
The only way I have figured out how do do this is to run the following
xp_cmdshell 'isql d- %@mydb% i- c:script.sql'
inside a loop.
My problem is that xp_cmdshell refers to the server c drive instead of my local c drive, where my script file is.
Is there a way to refer to my local c drive? Also any thoughts on a better way to approach this (other than running the entire script inline in the sproc since I don't want to have to run quotes around each batch of the script).
Thanks
Accessing Data Base From Remote Computer
Feb 23, 2007we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped.
View 2 Replies View RelatedAbout Accessing SQL Server2005 Database File From A Remote Computer
Jun 5, 2007hi every one. i am a new user of asp.net 2.0 using C# code and i am facing a problem in accessing a SQL Server2005 database file in the remote computer. i have connected two pc with peer to peer connection and trying to add a databse using the "Add connection" option from the visual studio 2005. in the add connection dialog box it is showing me the remote server and it was supposed to show all the database in that SQL Server when i select one. but when i am choosing the server name it was not showing me anything. by the way i have configuered the surface area for "both TCP/IP and named pipes" and both the pc's server browser is turned on. is it the right way to access a database file from a remote pc or not?? please send me a good solution to do this things and try to explain the codes with example. waiting for response....plz send me the solution.. as soon as possible
View 2 Replies View RelatedHow 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
Jul 20, 2005If I change the name of my computer/server will it change the name ofmy sql instance?
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
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 ......