Accessing A Remote SQL Instance
Post moderated by XIII, please leave out the "irrrggent" in the subject line:
i'm using a SQL Server 2000.
now want i want is to make one of the machine on my local network
Machine one: i've installed the SQL Server 2000 with these settings
1) Use Local System
2) MixMode (Use Windows Authentication and SQL Server Authentication)
USER ID = sa
Password = sa
From Machine tow which has the program: the connection string is:
<<< Me.SQLConnection_Search.ConnectionString = "packet size=4096;integrated security=SSPI; Persist Security Info=true; data source= "the name of the instance on Machine ONE"; user id=sa; password=sa; initial catalog=DBNEW; Server="Machine One Name">>>>>>>
when i connect --> "connect faild to MachineOneGuest"
when i changed the SERVER to SERVER = "Machine One NameUser Account of the windows"
this message appear : "SQL Server does not exist or access is denied"
So what can i do.??????
View Complete Forum Thread with Replies
Related Forum Messages:
Probelm Accessing Sql Instance
Hi , I just put my files up on a web server. I can view my aspx pages..but when I try to login to the website I get the following; 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Can you help? I can understand that it cannot find the specified instance of sql server, however I don't remember ever configuring it look to at a specific sql server. When i created the site in web dev express edition and added the login controls and set the asp config tool to use internet security it created the database itself and so I didn't have to put a connection string in. I also cannot see a connection string in tthe web.config file. The aspnetdb.mdf file is there on the server. is this something i need to configure with the hosting company or do i set it in my webconfig file. Thanks
View Replies !
How Can I Prevent My Co-Workers From Accessing My SQL Instance..
Hi all In our office we have simple Network (LAN) and for some reason in each workgroup Computer in this network we have installed SQL-Server 2000. So far everything was ok but recently i noticed that my co-workers can easily access my Sql Server Instance through their Enterprise manager installed on their computers and then they can open my tables,view...and manipulate other objects. for better illustration i have created a Flash Movie from this process , please check the following Link : http://www.Parsisoftco.com/movie/Sql/Sql.htm How can i prevent others from doing so? Any help greatly Appreciated. Kind Regards.
View Replies !
Accessing SQL2005 As A Second Instance To SQL2000
I'm having trouble accessing SQL2005 Standard Edition as a secondinstance of SQL Server where the first instance is SQL 2000 EnterpriseEdition. I installed SQL 2005 as a named instance "SQL2005". Theserver is running Windows 2000 SP4 ON A 32-Bit machine. When I look inServices I see the SQL Server (SQL2005), SQL Server Agent (SQL2005)services there. I went into SQL Server Configuration manager anddisabled the named pipes protocol and only have TCP/IP and by defaultShared Memory enabled to rule out that named pipes is causing theproblem. In SQL Server Configuration Manager I created an alias"computername$SQL2005" and was able to connect to database engine"computernameSQL2005" through SQL Server Management Studio WHILE ONTHAT BOX.But when trying to access the 2005 instance from another server(64-bit Windows 2003 SP1) I'm having trouble. On the 64-bit machine Idisabled the named pipes protocol for both "SQL Native ClientConfiguration (32-bit)" and "SQL Native Client Configuration". Under32-bit I created the alias "machinename$SQL2005" to point to the IPaddress of the 32-bit machine. In SQL Server Management Studio whentrying to connect to the database engine "machinename$SQL2005" itdefaults to the SQL 2000 instance. How do I access the SQL2005instance from a remote server?Any help would be appreciated.Mike
View Replies !
2 Instance Accessing Same Physical Db File In A/A Cluster
hi, I have 2 nodes, both active in windows 2003 cluster. both nodes have sql 2005 installations (master db & bin in local drives) with same instance name. Now my production db physical files are on a shared disk. I attached these files to my sql 2005 instance from node 1. then i took this node offline & attached same physical files from node 2. Now when the failback happens, i get an inconsistency error from my client app. can anyone help me achieve this ?? 2 nodes accessing same mdf file but only one at a time. Is there any architectural issue which wud prevent me from achieveing the ACID properties ? its ok if i have to manually run some batch file to trigger instance on/off. sql clustering/db mirroring/ replication is the last option for me. thanks in advance
View Replies !
Remote Accessing
Hello,I just uploaded a new SQL database to my hosting server.I am using SQL 2005 and SQL Server Management Studio.How can I remotely access the SQL database, on my hosting server, to create or alter tables and queries, using SQL Server Management Studio? Thank You,Miguel
View Replies !
Accessing Remote SQL 2005
Hi Experts, In SQL 2000, we have SQL Client which is used to access remote sql servers. What is there in SQL server 2005? I just want to install a client and not a server on my local boxes to access remote server. Any help is appreciated. Thanks Sachin Don't sit back because of failure. It will come back to check if you still available. -- Binu
View Replies !
Accessing My MS-SQL Database On Remote Web Site
I've downloaded a copy of Microsoft SQL Server Management Studio Express from MS. Can this product be used to query an SQL database at a web site. Conversely, is there a command line utility for running SELECT statement queries on my remote web site database?
View Replies !
Problem Accessing Remote Sql Server
HiWe had an sbs 2003 with isa 2000 server. We wre able to access aremote sql server (hosted at our web host) just fine. We replaced theserver with a new sbs 2003 r2 with isa 2004 server and even though Ihave opened port 1433 in isa 2004 we can't access the remote sqlserver anymore. Where can I look for any blocks?Many ThanksRegards
View Replies !
Problem In Accessing Remote Server
dear friend, i would like to write a stored procedure which is able to pick up data from remote server and store it in the local server is it possible to mention the server name in the select command waiting for reply ashish bhatnagar
View Replies !
Problem In Accessing Remote Data?
hi, I am trying to access data from a remote database which is on SQL SERVER from my local SQL SERVER.. the below is my query.. select * from Remote_server.Remote_DB.dbo.RemoteTable When i execute this query... I get a error message.. Server: Msg 7411, Level 16, State 1, Line 1 Server 'remote_server' is not configured for DATA ACCESS. I added my local server in the remote server as linked server can anyone tell me the sol... thanks
View Replies !
Remote Website Accessing SQL DB Tbl Nfo - Ideas?
I have a MS SQL 2000 db. It cannot be remotely accessed by other websites or by another MS SQL db (I have tried everything to make it do so). I am trying to figure out how I can use the data I have in a table to populate an asp page on another server/website not related to mine. I was told an XML page and using a JS script I could make the remote site read from my db. Not knowing XML, I am not sure if this is the correct way of trying to populate an asp page with data from my MS SQL table on my server to a webpage on another server. I do not want to give this person a connection script, or any kind of potential access to my db, but I do want the pages I develop for him to retrieve data I have in a certain table on my db without having to create a whole new db on his site. I want to control the content, add more content to both his and my website at the same time, so one table would be my best bet if I can get his site connected to my db table. These will not be read/write pages at all, just read only. They will not be "search" pages either, just data populated on a page from my db table. Is this possible? Ideas, thoughts, and suggestions welcome. Thank you.
View Replies !
Solution For Accessing Remote Ms Sql Database
Client machine has internal SQL server database. Client wishes to access that database for their registered employees and clients. What is the possible solution to access that Database and what securities involve in that? Is it also possible to access SQL server through PHP?
View Replies !
Problem Accessing A Remote Sql Server
Hi, I have an SQL server running on a Windows 2003 server in my LAN. I can connect to the SQL server using the enterprise manager. However, when I try connect to it from an ASP.NET application it fails and I get the following error: "SQL Server does not exist or access denied." I noticed that the user that runs the application (ComputerNameASPNET) does not have access to the SQL server. When I try to add this user I get the following error: Windows NT or user group ComputerNameASPNET not found... What am I doing wrong? Thanks.
View Replies !
Accessing Data Base From Remote Computer
we 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 Replies !
Damaged Accessing Remote SS2005 Database
I access remote MSSQL Server2005 (SS2005) databse over internet through SQL Server Management Studio (SSMS) in order to fine tune ASP.NET website using remote SS2005 database. Today I could not launch my SSMS http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2616564&SiteID=1 Is it possible that remote server machine or SS2005 damaged my SSMS. Can it be due to some incompatibilities, virus (I have Norton Antivirus locally) or something else? I do not have much experience with using SS2005 over internet. Can you share with me possible practical stories or theory on it?
View Replies !
About Accessing SQL Server2005 Database File From A Remote Computer
hi 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 Replies !
XP_CMDSHELL- Access Denied Accessing Remote Server
I am using XP_CMDSHELL to run 2 Windows commands (from a SQL 2005 SP2 server) that access files on a remote server (called webserver). The two commands are: 1. cscript.exe \webserverwwwrootEur_SaveProductImages.vbs 2. dir \webserverwwwroot Up until very recently this worked fine. Now I am getting Access Is Denied errors: For #1: Microsoft (R) Windows Script Host Version 5.6 Copyright (C) Microsoft Corporation 1996-2001. All rights reserved. CScript Error: Loading script "\webserverwwwrootEur_SaveProductImages.vbs" failed (Access is denied. ). For #2: Access is denied. This happens if the above commands are run through a job, or directly with Query Analyzer as SA. I understand that XP_CMDSHELL commands are run in the security context of the SQL Server startup account. The SQL Server startup account is called SQLServer and this account exists on both webserver and the database server. On both servers the username & password are identical and the user is in the local Administrators group. The two servers are in a workgroup. Things I have tried (with no effect): 1. Restarted the servers 2. Deleted and recreated the SQLServer login on both servers 3. Changed the startup account for SQL Server through the SQL Server Configuration Manager to another account and back to SQLServer. The most revealing tests are these: 1. If I log into the database server myself using the SQLServer account I can run the above commands in a Command Prompt with no problem 2. I installed SQL 2005 Express SP2 on webserver using the same startup account (SQLServer). If I run the same XP_CMDSHELL commands as above but accessing files on the database server, the commands work! So, an XP_CMDSHELL command run under SQL Express using the local SQLServer account to access a remote server works, but an XP_CMDSHELL command run under SQL Server using a local SQLServer account (that is supposedly identical to the same named account on the other server) does not work !!?!?!? It is almost as if XP_CMDSHELL commands run under SQL Server are NOT using the SQLServer startup account, but using some other weaker account. How can I tell if this is true? How can I get this back working (as it was a week ago). The only thing I can think that happened on the servers to cause this is the installation of Windows Updates. Thanks
View Replies !
Accessing Remote Sql Server 2000 ( Enterprise Manager Like Tool)
Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov
View Replies !
Connection Error To Remote SQL Instance, Over VPN
I am trying to connect to an instance of SQL Express through a vpn, simply using the SQL Management Studio, providing the server ip address x.x.x.xMSSQLSERVER, and using SQL authentication login. I receive the following message: Cannot connect to <server>, etc., etc. error 25: - Connection string is not valid Does anyone understand this? I am trying to connect through the SQL Server Management interface, not with a client program that would utilize a connection string. Is there something which prevents Management Studio from working over a vpn? To connect, I am using SQL authentication, and have verified the login and password locally on the target pc. The SQL browser service is running on the target pc, and I can telnet to the port which it is monitoring, through the same vpn connection. Remote connections are enabled for TCP/IP in the Surface Area configuration on the target pc. Any help appreciated.
View Replies !
Connecting To A Remote SQL Express Instance
Can anyone tell me what are the necessary steps if I want to connect to a Remote SqlExpress Instance ? I am using Visual Studio 2005. When I tried to connect it says that the remote server does not allow remote connection. I have enabled all the protocols from Sql Server Configuration manager and disable the firewall. But it still not working. Pls Help me. Thank You.
View Replies !
Error 26 Connecting To Remote SQL Server Instance
I am attempting something that I have done many times before; however, in this instance it continues to fail. I am trying to connect Management Studio to an instance of SQL Server 2005 Express over a VPN. The Management Studio connect dialog always fails with Error 26. I have: Enabled the instance for remote connections €“ both TCP/IP and Named Pipes Ensured that the instance is enabled for TCP/IP on the VPN address (10.2.1.1) and on port 1433 Ensured that the instance is running Ensured that SQL Browser is running Ensured that ports 1433 (TCP) and 1434 (UDP) are open on the firewall for inbound traffic Rebooted the server following this configuration to ensure that the instance services are refreshed Tried to connect from three separate clients (albeit on the same remote network) Disabled the firewall to ensure no further complications (as a last resort) I have this exact same setup functioning on a separate server. There is an additional backstory to this problem; however, I will not complicate the scenario with it now. If you feel you can help then I can elaborate further on the server€™s history. Thanks James
View Replies !
Connecting To A Local Instance From A Remote Computer
Greetings friends, Not sure if this is the right place for my question but here goes anyway. I have an instance of SQL Server 2005 installed on my DEV PC. A colleague of mine wants to access my server from his machine which connected to the same network. I logged on to SSMS and added him as a new login. Will he be able to connect to it now or do I have to do more than just that? Your help would be appreciated.
View Replies !
Cannot Connect To Remote SSRS Instance With SSMS
I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed. When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message: "The underlying connection was closed: Could not establish a trust relationship for the SSL/TLS secure channel. (System.Web.Services) Additional Information: The remote certificate is invalid according to the validation procedure. (System)." Obviously, this is a SLL issue, but, not being a security guru, I have no clue on how to fix this. I do know the certificate is valid, not expired and properly working. Both installs of SSRS are set up using the SSL certificate. Also, I am not connecting to SSIS with Management Studio, as I heard there is a bug connecting to both SSRS and SSIS at the same time. Anyone have any ideas? Thanks!! Jeff
View Replies !
Remote Client Connecting To A SQL 2005 Instance.
Good afternoon, I currently develop/maintain VB 05' apps for PDA's and desktops. I've got a scanner app that scans labels to build/transmit orders via an HTTP byte stream. I'm currently building an inventory app that resides at the remote client (windows not web) and can eventually connect to my SQL Server @ corp. At this point SQL 2005 endpoints work on the internal network but fail to resolve remotely. I've read about connecting to a SQL Server via HTTP with ip specs embedded in the connect string but havnt been able to find an example. Outside of creating a VPN for connectivity, can anyone recommend connection ideas for my scenario? Is it true that endpoints are only recommended for intranet consumption? Thanks, ChrisG
View Replies !
Selecting Version Of Remote SQL Instance Into Local Variable?
Hello all, I'm a bit new to SQL Server and T-SQL (my background is in DB2), so hoping you can help me with this. I'm writing a T-SQL script that's hopefully going to scan a bunch of SQL server instances and record the results. We've got a mix of SQL2K and SQL2K5 instances, and for part of my script I only want to run something if the remote instance is SQL2K. I'd tested this on my local PC with several instances created and it worked fine. When I try and run it for instances located on other servers it barfs :eek: . From what I've found from looking up the error message it looks like I've got myself a loopback -- but I don't know how to get around it - any ideas please? DECLARE @tempdata TABLE (scratch sql_variant) DECLARE @debug tinyint DECLARE @server sysname DECLARE @version varchar(20) SET @debug=1 SET @server='SQLSERVER_INSTANCE' INSERT INTO @tempdata (scratch) EXEC ('[' + @server + '].master.dbo.sp_executesql N''SELECT SERVERPROPERTY(''''ProductVersion'''')''') SELECT @version = convert(varchar(100),scratch) from @tempdata DELETE FROM @tempdata IF @debug>0 BEGIN PRINT @server + ' is running SQL Server version: ' + @VERSION END IF charindex('8.00',@version) > 0 BEGIN PRINT 'SQL2K-only code goes here' END The error I get is: OLE DB provider "SQLNCLI" for linked server "SQLSERVER_INSTANCE" returned message "The transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "SQLSERVER_INSTANCE" was unable to begin a distributed transaction. I get this error running from a SQL2K5 instance against both SQL2K or SQL2K5 TIA, moff.
View Replies !
Connect To Remote Instance Of SSIS From SSMS Using SQL Login?
I have installed a SQL Server 2005 Standard Edition instance with SSIS on Window Server 2003 x64. From my PC, I am able to connect to the Integration Services on the server using Windows Authentication but not with a local SQL login - and the option to change authentication methods is greyed out. Is it possible to remotely connect to SSIS using a SQL login rather than a Windows login? If so, any ideas or references for configuring it as such? Thanks. - Lance
View Replies !
Service Broker Message On Remote Instance Not Working
I was trying to send a message on a different instance in the network using service broker. I have created the endpoint and route both the side. I could see that the messages are in the transmission_queue in the sender side with no error in the status. What could be the reason. I am doing the following: CREATE ROUTE inst02 WITH SERVICE_NAME = 'SERVICE2', ADDRESS = 'tcp://10.14.43.149:2341' in the send script i am using this: BEGIN DIALOG CONVERSATION @dialog_handle FROM SERVICE [SERVICE1] TO SERVICE 'SERVICE2' ON CONTRACT [MainContract] WITH ENCRYPTION = OFF ; in the sending side if i change the endpoint's authentication as windows kerberos , then i get thefollowing error in the transmission queue: "Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 66." I also have given access to the remote user on this endpoint(on the recever side) using this : GRANT CONNECT ON ENDPOINT::Endpoint_test to paras I am executing the sending side send script using the same user wich has access to the remote endpoint. Can some one resolve this issue. Thanks
View Replies !
How To Go Around The SQL Server 2005 User Instance Problem When Using Remote Desktop
ProblemWhen Remote Desktop to my main office machine, and when trying toconnect to SQL Express, I was becoming increasingly frustrated with thefollowing error:Error: 'Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connectionwill be closed.'What is the solution?Solutions: ( pick any of the 3)1. Obtain and apply the patch http://support.microsoft.com/?id=8966132. Wait for the next Windows Service pack3.Of course if you can not get the patch, you can always do this (Note:You must have WinVnc server running in your remote computer)1. In the remote desktop session, reboot your computer.Click Start->Windows Security->Shutdown->Restart.Wait for some time to get machine up.2. Use your vncviewer to login to your remote computer. You can chooseto do all work via VNC or go to next step.3. Use remote desktop to login (this automatically closes the winvncsession).There you go, You did not create a remote session, but reused yourlocal session.
View Replies !
Cannot Connect To Remote Named Instance Of SQL Server Express Edition (error 26)
Hi all, One of our customers is running a Dynamics NAV database on a SQL Server 2000 instance. They host several webshops externally, which are fed data from the NAV database using SQL Server Replication. I've installed the SQL Server 2005 Client Components on the SQL 2000 machine, to be able to connect to the hosting provider instances. Hosting provider A runs SQL Server 2005 Standard Edition (Default instance), Hosting provider B runs SQL Server Express Edition (SQLEXPRESS instance). We've got the replication working for hosting provider A. For hosting provider B I'm trying to add a subscriber (SERVERSQLEXPRESS) and it keeps failing with error 26 - unable to connect to server/instance. We've checked all the items in http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx and could not find anything missing. I can connect to SERVER, and strangely end up in the named instance, but adding server as a subscriber generates an error saying SQL Server 2005 replication does not accept aliases, IP addresses, etc. and that I need to connect to the correct SERVERINSTANCE in order to add it as a subscriber. We've now opened up the firewalls completely between the machine at our customer and the one at hosting provider B, so that pretty much rules out any blocked ports. Can anyone pleas help??? Thanx, Jeroen
View Replies !
ODBC Connection To Remote Computer Giving Invalid Instance() Message
I am trying to set up a ODBC connection to a remote database using the ODBC data source administrator. I am getting an error message complaining of an invalid instance(). The database I am trying to connect to does have a default instance and a named instance. Do I need to specify the instance name somewhere in the connection settings? I tried specifying the server name as <Remote computer IP Address>/<Instance Name> but this didn't work. Any ideas?
View Replies !
Communications To The Remote Server Instance Failed Before Database Mirroring Was Fully Started
command in principal server ALTER DATABASE database name SET PARTNER = 'TCP://<mirror_server_name>:5022' return: Msg 1413, Level 16, State 1, Line 1 Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started. This problem is only in production database any testing database include adventureworks mirroring sucessfuly. Why is problem:? size? database > 9GB slow HW? Principal database Intel D 3Ghz,4GB RAM, 4x 15k RPM HDD RAID 5 / Mirror database 2x Xeon 3Ghz,4GB RAM,6x HDD 10k RPM RAID 10 Slow LAN? both servers connect 1Gb/s please help me THX
View Replies !
MSDTC - Remote Accessing SQL Server 2005 From A Desktop Application - Windows 2003 Server
Hi, I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like 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. But my SQL Server allows remote connection, and I am able to do a select statement. But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
View Replies !
Do I Need To Create A Domain To Get Connectivity To A Report Server Database On A Remote SQL Server Instance?
I'm setting up a simple SSRS implementation for a non-profit organization, using two servers hosted at a data center. The first server has SQL Server Standard Edition and Reporting Services installed. I've designed and deployed a number of useful reports on this server. I was hoping to isolate this first server by installing IIS and SSRS on the second server, have users browse from the Internet to that second server (over SSL, of course), and have all reports served up from databases (and, presumably, the report server database) on the first server. During the installation of SSRS on the second server, however, I'm being prompted to specify the service account. According to the help text: "Reporting Services. Service accounts are used to configure a report server database connection. Choose a domain user account if you want to connect to a report server database on a remote SQL Server instance. If you are using a local report server database, you can use a domain user account or Local System to run the service." I believe I want to configure SSRS to connect to a report server database on a remote SQL Server instance; therefore, it appears that I need to enter a domain user account. The only problem is, neither server belongs to a domain; they are members of a simple two-server workgroup. Does SSRS, configured to connect to a report server database on a remote SQL Server instance, require a domain? Does what I'm hoping to accomplish require a domain? Creating a two-server domain seems like overkill for this implementation, doesn't it? I appreciate any comments and suggestions. Thanks!
View Replies !
SSRS In Scale-out-Deployment (Joining A Remote Report Server Named Instance To A Scale-out Deployment)
Hello We configured SSRS in 2 Instances (web server's). MNA01 and MNA02, Which have IIS 6.0. We have SQL Server Database (Report server DB, Report Server Temp DB) The table Keys in the Database is having 2 values, one for MAN01 and one for MNA02. Shall we have 2 values or 1 value in the table "Keys"? I have seen the article says we have to Join the Keys using the rskeymgmt utility. (Joining a Remote Report Server Named Instance to a Scale-out Deployment) Note: A report server scale-out deployment refers to a deployment model where multiple report server instances share the same report server database. A report server database can be used by any report server instance that stores its symmetric keys in the database. For example, if a report server database contains key information for three report server instances, all three instances are considered to members of the same scale-out deployment. Please advice for the correct configuration of SSRS in scale-out-deployment. Thanks in advance. Jay
View Replies !
How Can I Migrate All Objects Alogwith All Constraints,SP,Triggers Etc From Development Instance To Production Instance
Hi fellows, I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied. can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance. This is Sql server 2000 Cluster environment. thanks in advance for any help rahman
View Replies !
Uninstalling SQL Server 2000 Instance On A Mulitple Instance Platform From Command Line
I have a situation where we need to uninstall a SQL Server 2000 instance from the command line using the REMOVE=ALL option along with the INSTANCENAME option in the uninstall process. This must be done from the command line and not through the operating system. We will then install a SQL Server 2005 instance to replace the old SQL Server 2000 instance. My question is whether or not performing an uninstall using the mentioned options will "break" other SQL Server 2000 instances on this server or will they continue to function normally? I know under SQL Server 2005 the REMOVE=ALL option will remove all the shared components and certain instances will be "broken"; does the same thing happen in SQL Server 2000?
View Replies !
Default Instance Files And Named Instance File Paths
Hello FacultiesWhen SQL2000 is installed as a default instance, all its supportingfiles as installed in MSSQL directory. And after installation as anamed instance, the files are added to the MSSQL$InstanceNamedirectory. If i keep the default instance files on the primarypartition and those of the named instance on another partition, willit cause any trouble? Please help.Thanks in advanceDebashish
View Replies !
Migrating From SQL2K Named Instance To SQL2K5 Default Instance
Hi, I have a task in hand to migrate (upgrade) from SQL2K named instance to SQL2K5 default instance. There are many intranet applications touching current SQL2K. I would like to perform this upgrade such that I don't have to touch any application code - meaning I don't have to change the connectionstring to point to new Default instance. How can I achieve this? So, in otherwords, here is what I want to achieve: Current Server: SQL2K: SERVER_AINSTANCE_A (named instance) Upgraded Server: SQL2K5: SERVERB (default instance) If I have both default, I could achive this by setting up DNS alias after migration done so that any call for SERVER_A would point to SERVER_B. But in my case, I don't have SERVER_A, I have named instance. Is there any solution? Regards, Vipul
View Replies !
How To Move A Single Database From SQL Server Instance To New SQL Instance
Hi, I want to move one database from the source SQL Server 2000 instance to a new SQL 2000 instance in another machine. I have five user databases in this source SQL instance. How should be my approach to move this single database out of this ? My understanding is restoring this database in the new instance, copying all logins to the new instance and then copying the jobs, DTS packages, alerts, operators only specific to this database will do it. Please let me know if this is exactly what I should do .. Thanks in advance.. Regards, Himansu
View Replies !
Named Instance Problems (Default Of 7.0/2000 Instance)
I am trying to set up a Named Instance of SQL 2000 on the same machine that has a default instance of SQL 7.0. The setup always completes and I am able to register the Named Instance of the SQL Server with which it was installed on. However, when I try to connect the users to the database, with both windows and SQL authentication, I receive a SQL server not found error. I have tried an alias setup as well as physically specifying the port number in settup up an ODBC connection. Has anyone ran into similar problems? Also, has anyone been able to successfully complete the process as mentioned above?
View Replies !
How To Move A Single Database From SQL Server Instance To New SQL Instance
Hi, I want to move one database from the source SQL Server 2000 instance to a new SQL 2000 instance in another machine. I have five user databases in this source SQL instance. How should be my approach to move this single database out of this ? My understanding is restoring this database in the new instance, copying all logins to the new instance and then copying the jobs, DTS packages, alerts, operators only specific to this database will do it. Please let me know if this is exactly what I should do .. Thanks in advance.. Regards, Himansu
View Replies !
How SQL Server2000 Client Instance And Server Instance Works?
Hi all, i have installed SQL client instance on my Desktop "Machine-A", and i used to connect to SQLServer2000 running on another "Machine-B" by using valid username and password. i created a DTS package and i used to run it. im very confused how the communication happens between the two machines and which process run where and which initiates which and which machine allocates waht resources. im really interested to know all these things. if any one know plz help me out. Thanks in advance.
View Replies !
Move SQL2005 From Default Instance To Named Instance
I have a server with sql server 2005 installed as the default instance -- I have a piece of software that needs SQL2000 to be the default instance. Is there a way other than install new sql2005 named instance and move databases to rename my SQL2005 instance from <machinename> to <machinename>sql05 for example? Bryan
View Replies !
Installing A Default Instance AFTER A Named Instance???
I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server. It is a Production Server with 3 NAMED Instances and NO Default Instance. Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances???
View Replies !
Migrating From Named Instance To Default Instance
I installed SQL Server 2005 recently on a cluster. I didn't go for the default instance and instead I named the instance option. Now I would like to migrate everything from the named instance to the default instance, which I haven't yet installed. Is this an easy process? What about the logins and the maintenance plans and jobs? Is there anything else I need to be aware of?
View Replies !
Create A Named Instance On Top Of A Default Instance
Hi I've never had to do this, but when I downloaded the Web Workflow Approvals Starter Kit, it requested that I install the database into a User Instance of .SQLEXPRESS. Now the problem is, I've installed it onto a default instance, so I was wondering whether you can create a named instance on top of a default instance... and if so, how would you do that? Cheers Chris
View Replies !
Single Instance/Multiple Instance/Virtualization Q
I work for a mid size company with the usual collection of enterprise applications. We are trying to consolidate our SQL environment consisting of around 100 databases none of which are over 100GB with the average database size around 5GB. Recently a large server was purchased as the "Big Daddy" SQL box. Obviously not all the databases will be moved to this one box but within reason a number can. My question: What is the best way to configure the box? 1 OS & 1 Default Instance - How do we isolate loops memory leaks etc... 1 OS & Multiple instances, ie:Dedicated instance for each application. - How do you allocate CPU & memory, allow for optimum performance without putting others at risk from a rouge process? Virtualized OS for each application with a default instance - Too much overhead impacts performance? Future plans include offsite replication, perhaps mirroring with failover. I'd appreciate anyone else's thoughts ideas? How have you tackled this problem in your environment? Thanks Scott
View Replies !
|
TRACKER
