How To Know Whether A Computer Is A Sql Server According To The Name Of Computer?
May 9, 2004Thanks a lot
View 6 Replies
ADVERTISEMENT
Renaming The SQL Server Computer Name
Oct 10, 2001Do I have to re-install SQL2000 if I change the Win2000 Server name.
Thanks
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 RelatedConnecting 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 RelatedMoving 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?
How 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 ......
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?
Gettting Time Of SQL Server Computer
Jul 20, 2005Hi everyone,Is there a system stored procedure or another way that I can retrievethe current date and time of the SQL Server computer?Any info would be appreciated...Thanks in advance,Dan
View 1 Replies View RelatedServer Name , Instance Name, Domain Name Computer Name
Mar 28, 2008I am still trying to figure some last issues before installing sql 2005 standard edition.
vista issues, sql 2005 sql sp2 etc
My question is simple actually, It is about configuring administrative accounts on my computer.
I wish to use configure the administrative account?
I wish to use a third party in deploying sql reporting services
Do I need to set up a local account in report manager?
the article in setting up reporting services in vista
uses domain/instance name or computer name/instance name
how do I do correctly set this up? I will be using july 2007 dvd for
sp2 ( I believe) is their any article explaining the steps in sql sp2
some people seem to have trouble in the restore step.....Thanks
I just want to be prepared....can I install cd's without the use of the internet....
Uninstalling Sql Server 2005 From My Computer?????
May 7, 2008i am having some issues..hopefully someone can help me..i just finished my database class...we had to install sql server 2005...i am running windows xp home...when i went to install sql...there was one error that i was getting...it was about the iis function, which i know that it won't work with the home edition...i finished the install, without the iis, so i can try to work on some things for class...i also had to install northwinds and pubs...now that the class is over, i want to get rid of it all...i tried to follow somewhat of the uninstall process but now i am getting problems...i can't figure out how to uninstall the northwinds and pubs..it keeps saying that it is being used by another person or program and it won't let me uninstall....can someone what me through the uninstall process of both the northwinds, pubs, and all of sql server 2005...i don't know much about computers....thanks you so much for helping in advanced...
crystal
How To Access Sql Server Express From Other Computer On The Netwrok
Jan 8, 2007Hi expertsI use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error. Thanks
View 2 Replies View RelatedSQL Server 2005 Developer Edition And Vwd On Same Computer
Feb 9, 2007Will SQL Server 2005 developer edition and Visual Web Developer Express
work on the same machine? One reviewer of SQL Server 2005 developer
edition on amazon.com stated won't work on the same machine? Is this
true?
Backup A Remote SQL Server To Local Computer?
May 4, 2005Is there an easy way to backup a database on a remote SQL Server to a backup file on my local computer?
View 3 Replies View RelatedHow To Open And See The MSSQL SERVER Tables In My Computer ?
Nov 9, 2004Hallo everyone
Now I have to analyse so many Software systems that my company is using and I have to extract the Datamodels behind these systems.
One of these systems is developed with a MSSQL server backend. Now I have to open this server tables and see the table structures and data directly how we see in Access.
Please help me by telling the way to open this database.
any help is very much appreciated.
:) thanks in advance.
Running SQL Server 2000 And 2005 On The Same Computer
Nov 4, 2005Does anyone know whether or not both versions can be installed on the same machine?
View 1 Replies View RelatedUnable To Connect Second Computer To SQL Server Database
Aug 11, 2006Hello all,
New forum member here, and pretty new to SQL Server. My question is I'm having an impossible time trying to connect MS Access on Computer A to a database running on SQL Server 2k (SP3) on Computer B. Every time I try to create a new ODBC connection on Computer A, I get the dreaded Server Error 17 (SQL Server does not exist or access denied). I have no problems making the ODBC connection on the computer running SQL Server (Computer B).
My connection settings are as follows:
Computer A name = MAINDESKTOP
Computer B name (contains SQL Server) = HOMELAPTOP
Workgroup name = WORKGROUP
Server Properties:
Name = HOMELAPTOP
Authentication = SQL Server and Windows
Registered SQL Server Properties = Use SQL Server authentication, and I'm using a login name and password
Server Network Utility = TCP/IP network protocol enabled, with default port 1433
Server Client Network Utility = TCP/IP network, default port 1433
Under "Security", I have created a new login using SQL Server Authentication called "bradley", and have assigned a password to the new login. I've noticed that when I open the login properties dialogue, there are always more ***'s in the password field than the number of characters I originally used, but I suspect that's normal. I have assigned a database called "Costume" to "bradley", and have verified that the permission is checked on the Database Access tab for user "bradley".
Under "DatabasesCostume", I have verified that there is a user called "bradley" with the same login name and user name.
No matter what I try, I can't get Computer A to connect to Computer B's SQL Server database. I have no problems with any other types of connections (pinging, internet, file transfers).
This can't be that difficult! Any ideas?
Thank you!
Brad
How To Check Using If SQL Server Is Running On A Remote Computer
Jan 21, 2004I am about designing an access project file that connect to a SQL Server database : it could be either on the local computer or a remote workstation, this depending on where the front end is running.
Bypassing the default log on dialog box i have set my own form that users should use to connect on adp. Then using baseconnection string i connect the adp to sql server database.
My concern is how can i check from vba if the instance of SQL Server where my back end database is located is running in order to make
users knowing that due sql server service status off their connection
tentative will fail.
inform u i can check same from console management however i would to automate same controle from my adp and avoid that users have to operate such task...
Copy Files From Another Server To Computer With Robocopy And Job
Feb 4, 2015I have one job for copy files from another server to my computer using Robocopy.but when I execute my job in sql server I get this error:
Accessing Source Directory 192.168.101.191Upload
Access is denied.
this is my job:
USE [msdb]
GO
/****** Object: Job [Test] Script Date: 02/04/2015 13:08:00 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 02/04/2015 13:08:00 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
[Code] ....
Should I create Credential and proxy?How can I do this?Would you mind giving me required scripts for this?
Conecting To Report Server On A Remote Computer
Apr 7, 2008
Hello,
i'v installed a pogram that uses SQLEXpress and reporting sevices on a clients computer. I can acces the reports wih http://localhost/reports$SQLEXpress from that computer, but i can't reach them from other computers in the netwok by typing http://servername/reports$SQLEXpress
i am asked to imput a pasword for user "servername/guest" (which i do not know and dont think there is one) and then get the following:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials you supplied.
Please try the following:
Click the Refresh button to try again with different credentials.
If you believe you should be able to view this directory or page, please contact the Web site administrator by using the e-mail address or phone number listed on the preactor home page.
HTTP 401.3 - Access denied by ACL on resource
Internet Information Services
What should i do to solve this problem?
Regards
Darius
Connecting On One Remote Computer But Not The Other On Sql Server 2005
Feb 15, 2007I am unable to connect to a remote server on Computer A from Computer B, but when I reverse it I am able to connect to a remote server on computer B from computer A. I have SQL Server 2005 Developer Edition on both computers. I am using the using the SQL Management Studio to connect. Both Computers have these settings
Using Surface Area Configuration both have local and remote connections checked. Both computers using tcp/ip only checked.
Using Configuration Manager both the sql server and the sql browser are running. Both computers have tcp/ip protocols enabled.
Under the server properties on both computers, under the Security Tab, I have SQL Server and Windows Authentication Mode checked. Under the Connections tab I have Allow remote connections on this server checked.
I believe I have the Security for both the server and databases done properly giving them both proper Logins and User Roles with the proper permission.
Also went to my window firewall settings and under the Exceptions tab, I added both the sql server.exe and sql browser.exe programs on both computers on my remote network.
But when I connect on Computer B, I get an error message stating:
TITLE: Connect to Server
------------------------------
Cannot connect to 'ServerName'
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
----------------------------
I tried pinging server a and then server b and they both pinged.
Could someone please tell me what could be wrong on my remote computers.
Cannot Start Report Server On Local Computer
Jan 20, 2007HI,
I tried to deploy reports on locahost. Yet, I still need to start the mssqlserver service on local computer. I tried all the possibilities shown from the help but still i can't have it started. How will i start mssqlserver service on local computer alone?
thanks
Renamed Computer And Connected To Sql Server Without Problem...
Sep 5, 2005I 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 View RelatedMove SQL Server 2005 Instance To Another Computer
Apr 14, 2008I have SQL server 2005 on a Windows 2003 machine. The machine is old and I need to move the entire SQL server to a new machine. There are many databases and users that need to move across to the new server. Detaching and attaching the databases would be tedious due to the large number of databases. Is there a way of moving the DB's and SQL users to the new machine without having to do each db one at a time?
Additional info that might be helpful:
The new server's IP address and name must also change to that of the old server.
The old server initially had SQL 2000 on it and was upgraded to SQL 2005.
The new server was installed with SQL 2005 only. Hence the Database and log paths differ between the old and new server.
Any help would be appreciated.
How To Unintall Sql Server 2005 Complete From My Computer ?
Aug 30, 2007I have installed SQL server 2005 and after I uninstalled it. and tried to install again but my computer recognize the old version of Sql Server 2005 and only allow to install documentation and client components
How to unintall Sql server 2005 complete from my computer ?
How Do I Test Whether The SQL 2005 Server Has Been Installed In My Computer?
Mar 6, 2007The prerequire componets for my program are:
1.sql server 2005 engine
2.sql server 2005 reporting services
3.sql server 2005 analysis services
4.sql server 2005 integreted services.
so how can i detect wheter the destination computer has installed the above components or not?
Can I Install Both Version Of SQL Server 2000 && 2005 On My Computer ?
Oct 11, 2006I now know only I can install both .Net 1.1 and 2.0 on one computerbut I don't know, Can I do it on SQL Server ? Please advise me....
View 8 Replies View RelatedHowow To Move Sql Server 2005 Database From One Computer To Another ?
Nov 25, 2006
Hi,I need to know the way in which I can copy my sql server 2005 database from one computer to another ?
Please I need a clear and complete explanation ,thanx .
Allowing A Conenction To A SQL Server 2005 Database From Another Computer On A LAN
Mar 8, 2007I am working with one other person on a VS 2005 vb.net web project that accesses SQL Server 2005. Both the computers are connected and my partner can run the application on his computer from his VS 2005 but we are getting an error on our first databind to a gridview on the page we are trying to run the error is below
A connection was successfully established with theserver, but then an error occurred during thepre-login handshake. When connecting to SQL Server2005, this failure may be caused by the fact thatunder the default settings SQL Server does not allowremote connections. (provider: Named Pipes Provider,error: 0 - No process is on the other end of the pipe.)
I check the properties of the SQL Server and the check box is checked that says allow remote access. I am not sure what to do.
Can I Install The SQL 2005 Express Beside SQL 2000 Server To The Same Computer?
Jan 18, 2006Hello,
Sorry for my question, I know, that there were several topics about sql 2000 vs SQL 2005, I read all them but unfortunately I haven't got the correct answer. I must install my intranet application that uses asp.net 2.0 and SQL 2005 Express to a Windows 2003 server with SQL 2000. It is possible to install SQL 2005 Express beside the 2000 server? It is very important, because I have no possibility to test and that Win2003 server there are a few programs that use SQL 2000. What will happen with the 2000 databases and their programs if I install the 2005 Express to the server? They will work fine with 2000 and my application will work with 2005?
Or instead it should I configure my application to use 2000 capable connentionstrings?
Connecting To Sql Server From Local Computer Using Client Tools
Jul 15, 2004Hi,
I just installed SQL Server for the first time on a windows 2003 OS which is on its on server. Then, I installed the client tools on my local computer. Now how do I connect to the sql server with my client tools? What I wanted to do is from my local computer use the enterprise manager and pull up the databases that are located on the server that contains the sql server.
Thanks a bunch,
Laura ;)
Retrieve Local Time From Remote SQL Server Computer
Feb 6, 2004Hi all
I am about updating some fields with local date and time using blw API
Quote
Private Declare Sub GetLocalTime Lib "kernel32" (lpSystemTime As SYSTEMTIME)
Public Function LocalDateTime()
Dim MyTime As SYSTEMTIME
GetLocalTime MyTime
Debug.Print "The Local Date is:" & MyTime.wMonth & "-" & MyTime.wDay & "-" & MyTime.wYear
Debug.Print "The Local Time is:" & MyTime.wHour & ":" & MyTime.wMinute & ":" & MyTime.wSecond
End Function
Unquote
This works fine however due to it's not really easy for an administrator to keep checking every times wheter local date and time are correctly updated for each front end users computer i would that to reconsider my function and making it to read local date and time from remote SQL Server. my concern is to help administrator to save time as he should only need to ensure that Server is running with correct time...
thkx for any advise
SQL Server 2008 :: Restore Database From Raw MDF And LDF Files Of Old To New Computer
Aug 18, 2015I have a client that has POS software called Restaurant Pro Express (RPE) from www.pcamerica.com
Their old POS computer had a hardware failure, but I was able to attach the hard-drive to another computer and recover the data. RPE uses a MSSQL database system. However, my client doesn't seem to make backups very often - the last one is dated January 5, 2015.
I was able to copy the C:Program FilesMicrosoft SQL Server folder over which contained the instance as well as all the data files - and has up-to-date information. The instance in the recovered Microsoft SQL Server folder was called MSSQL.1. I installed the RPE software on their new computer, and it too now has an instance called MSSQL10_50.PCAMERICA. The new computer is using MSSQL 2008 R2, while I believe the old computer would have been using MSSQL 2005.