I have a clustered environment where I have virtual servers running and I have SQL 2005 on one of the virtual servers. Is there any way to have multiple SQL instances running on one virtual server, if so how? If this is not possible than what are some of my options?
Thank you,
Kern Probation
Guys,
We have existing SSRS farm (3 web servers total) with single virtual IIS servers on each box.
We need to add couple more virtual IIS server on each box.
And these virtual IIS need their RS as well.
Web applications are written by independent vendors. They all have different IP/domain name.
All web app have own Reports & ReportServer virtual directories.
I was thinking of sharing ReportServer windows service and RS databases.
Is it possible? What would be best setup route?
Thanks,
OK
Is virtual server the same as creating more than 1 instance of SQL Server?
Thanks!
Hi,On my laptop I am running Virtual Server 2005 with 2 x Windows 2003Servers. Both the VS can access the internet and shared files on thehost laptop. On the host laptop I have a SQL Server 2000 running.I have written a Windows Service to detect Application Errors and fireduplicates of events to the database, and this service sits on both VS.It does work as I have tested it on host. BUT everytime I makeapplication errors on the VS nothing is deposited into my database.Very frustrating!I have also tried to create a ODBC connection through the Data SourceAdministrator, and when I enter the login credentials for SQL I getconnection error messages.Any suggestions would be great!ThanksSun
View 3 Replies View RelatedI have a question regarding the nature of virtual sql servers, specificially what protocol is used to communicate to the server when a request is made by a client.
For example, if a scheduled job is run on the virtual sql server, what determines the protocol used (e.g. TCP/IP, named pipes etc.) by SQL Server agent? Is it the client network alias set up on the virtual server?
I am asking because currently the client aliases on some of our virtual sql servers are using named pipes and I think this is causing a problem with our backups.
Thanks,
Adrian.
I
am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set
the cluster up through Virtual Server 2005 with 2 virtual nodes and one
virtual domain. The nodes can connect to each other as well as the
physical machine. When I try to install a fresh copy of SQL 2005 on my
cluster, I get an error every time. The
error stops the installation while checking system configuration after
installing prerequisites. The log file entry is as follows:
*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:
IIS is not installed, therefore Report Server feature will be disabled
Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastoreclusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
I am unable to successfully complete an install of Visual Studio 2005 with SQL Server 2005 Express on a Virtual PC 2004 image, which seems to be a pretty reasonable expectation. The installation completes successfully all of the way through in a Windows XP Pro SP2 image, but at the end the installation program informs you that SQL Server Express has failed to install, with no other explanation. No setup log files give any information as to why the installation failed. Then I see in the fine print for SQL Server Express downloads that "There is no support in this release for Virtual Server, Virtual PC". (http://download.microsoft.com/download/c/c/6/cc66b572-a402-4c6a-8233-b9c7d05840c7/RequirementsSQLEXP2005.htm)
View 3 Replies View RelatedSql 2005 Enterprise fails to install on a 64 bit VmWare Windows 2003 virtual server. All componets install up to including the Reporting services. The next componet (I believe it is the management studio portion) fails to install. I have moved the install files to the local machine and this did not help. If someone knows how to fix this please share.
Dave Hensley
Hello All.
I have a failed sql cluster setup on Windows 2003 OS cluster. sql will not uninstall on node 1 because it says the group name was not specified in the template.ini file for the cluster. The OS cluster nodes have been evicted from the cluster. The OS cluster is no longer available to provide a group name for.
SQl uninstall process process is failing because of the error mentioned above.
I want to completely , uninstall SQL server from both nodes,
clean up Windows Server and install just a default instance of SQL server on just one of the machines, The cluster can wait.
Thanks.
Hi guys
We are in the processes of finalising or server architecture for our production environment and the proposal that has been put forward is to run the database within SQL Server 2005 which is running in a virtual machine. It is thought (by some) that this provides a very high degree of redundancy as it will use ESX server and will have multiple servers in the farm that it can move to in the event of a server crash (which i admit makes a degree of sense).
I however am worried about performance. I release as soon as you go to virtual you loose some raw power because the box is busy running the virtual but more from the point of view that if we make cretin hardware resources available to the virtual would the server run the same as if it was running on a physical machine of the same specifications. For example, if 4gb ram and x amount of clock cycles where dedicated to the virtual would it preform the same as running it on a physical box 4gb ram and x amount of clock cycles. If the answer is no, any supporting documentation that anyone knows of would be greatly appreciated.
As a side note if it makes any difference the database data files and transaction logs are being sorted in an external SAN and not within the virtual image itself.
Thanks
Anthony
Hi All,
I have successfully installed MSSQL server 2005 on virtual machine running on XPSP2. No error messages were shown durring the installation. Still I do not see it working at all. There are no services insltalled for the SQL Server and it can not be accessed by any other applications.
If anyone has an idea why this is happening, please help?!
Thanks,
Georgi
I have sql server reporting services installed .
I have reinstalled the iis .
But now when i ever i reinstalled the reporting services i can't see any virtual directory in IIS.
SSRS installed successfully but no virtual directory
Now please let me help in making the virtual directories of sql server 2005 reporting services.
When I reinstall then if i try to connect with management studio I can't.
If i try to check surface area configuration i get following message
"Reporting services is not configured properly sqlsac"
Curious on how this will work.. if i install sql 2005 standard edition on one virtual server.. to a fixed disk (actually 2 fixed disks.. one for C, one for D).. then install another 2005 standard edition on another virtual server.. do i just rerun the setup and suddenly the failover cluster option will NOT be greyed out?
Can anyone comment on this?
Thanks in advance.
Will I lose performance?
View 7 Replies View RelatedI am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.
1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.
Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)
If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.
Thanks!
Brandon Forest
Database Administrator
Data & Web Services Team
Sutter Connect Information Technologyforesb@sutterhealth.org
Hi, i´m new to SQL SERVER, I've been using Oracle and MySql without problems so far.
I'm having problems to connect to SQL SERVER on my local machine.
**UPDATE
I can connect via command line, but from Visual Studio can´t connect to SQL SERVER
Sometimes I got this error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
And sometimes something about enabling remote connections in SQL SERVER , but the server is in the local machine.
what´s suppose to be the name of my server? localhost?
what am I doing wrong, ?
I have no problems to connect to Oracle and mysql with Visual Studio.
Thanks in advance
Hi,
I need to find out whether SQL Server client components are installed on a machine through my application.
For that I was expecting "SOFTWARE\Microsoft\Microsoft SQL Server\90" registry key. BUT If I install just native client drivers, this key is not getting created.
What could be another approch to determine whether system has required client components.
Also I need to list all the SQL Server 2005 servers available in the network. (Similar to the Servers combo box being populated while DSN creation in ODBC Admin tool). There are several approches.
1) Use NetServerEnum API
2) Use SQLBrowseConnect ODBC API
3) Use SQLDMO Object
4) OSQL utility.
Which one I should use VC++ (2005)?
Thanks in advance,
Mac
Hello,
I was wondering whether it is possible to query linked servers in SQL Server Management Studio Express 2005 if those servers linked to are SQL Server 2000 machines?
I have added some linked servers to express and queried them, however the login timeout is expiring. I thought it might be because of an incompatability.
Cheers,
Damien.
Hi, I am trying to use SQL Server 2005 Enterprise Edition to copy tables from my local server to my hosts server at brinkster.com. In the old version you could use DTS, but everything seems to have got far more complicated now! Please can anybody guide me in the right direction? Thanks a lot.
I have just installed SQL 2005 enterprise and every apeared to install ok. But using SQL config manager nothing is showing up under SQL 2005 Services tab.
Anyone got any ideas?
Hi All,
We have been experiencing issues with SQL Server 2005 SP2 upgrade on cluster servers.
After running the setup, it gives failure message for Database services.
Installing SP2 on 64bit cluster server we get error regarding "passive node not patched properly or run the setup from passive node". However, select serverproperty(€˜productlevel€™) returns the output as "SP2". On more digging we found from SQL Server Error log, that the resourcedb of that server is of level 9.0.0.3199
€œThe resource database build version is 9.00.1399. This is an informational message only. No user action is required.€?
However if we do the SQL Server 2005 SP2 upgrade on standalone machines with the same software repository, it upgrades successfully and also resourcedb upgraded to 3042 version. So if we look at the errorlog of a standalone machine it gives following message.
"The resource database build version is 9.00.3042. This is an informational message only. No user action is required."
I again reiterate that, this is the issue we have faced on 64bit SQL Server 2005 SP2 upgrade only on cluster SQL Servers, however on standalone machine it works fine and 32bit SP2 installation works fine.
Please let us know the solution for this.
regards
Jay Mehta
Hi, I hope someone can help me! I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!
My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start:
IP1
Active Yes
Enabled No
IP Address aaa.bbb.ccc.111
TCP Dynamic Ports
TCP Port 0
IP2
Active Yes
Enabled No
IP Address aaa.bbb.ccc.222
TCP Dynamic Ports
TCP Port 0
IP3
Active Yes
Enabled No
IP Address aaa.bbb.ccc.333
TCP Dynamic Ports
TCP Port 0
IP4
Active Yes
Enabled No
IP Address 10.1.1.1
TCP Dynamic Ports
TCP Port 0
IP5
Active Yes
Enabled No
IP Address 127.0.0.1
TCP Dynamic Ports
TCP Port 0
IPALL
TCP Dynamic Ports 2020
TCP Port 2020
Interestingly, the ip address that the server is listening on aaa.bbb.ccc.444 is not reported in the list of IP addresses in the configuration manager for this instance, yet it is when I view the available IP addresses for the other two instances - is this significant?
I have tried failing to the other node, changing it there, changing it at the console and also while logged onto the the virtual machine remote desktop, rebooting both nodes, etc, etc. There are two other instances on this cluster that are still working fine but I hvae not attempted to change the TCP ports they listen on.
I used the same method to change this default instance as I did for a named instance on a similarly configured cluster and it worked fine. How to fix this?
Regards, Mike
2007-02-27 12:03:17.69 Server Server is listening on [ aaa.bbb.ccc.444<ipv4> 2020].
2007-02-27 12:03:17.71 spid9s Starting up database 'tempdb'.
2007-02-27 12:03:17.72 Server Error: 26023, Severity: 16, State: 1.
2007-02-27 12:03:17.72 Server Server TCP provider failed to listen on [ aaa.bbb.ccc.444<ipv4> 2020]. Tcp port is already in use.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2007-02-27 12:03:17.75 Server Error: 17826, Severity: 18, State: 3.
2007-02-27 12:03:17.75 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-02-27 12:03:17.77 Server Error: 17120, Severity: 16, State: 1.
2007-02-27 12:03:17.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I have installed SQL 2005 (X64) on 64-bit Windows 2003 server (AMD). One of my databases need to connect several Oracle databases on 32 bit servers.
I managed to install Oracle 32 bit Client (was unsuccessful with 64 bit installation) and could set up the odbc (32). But I coul'nt find Oracle under linked servers!
Does anyone know what I need to do?
What is a virtual server?In my new job,my boss mentioned about moving the websites from a physical server to a virtual server.Why is this done or needed?
Also he insists that I buy and install SQL server 2000 enterprise edition in my laptop and use the enterprise manager to access their server.Can't I just download the client tools from their SQL package and be able to access their server?Do I need a CAL or is it just enough to have a permission in their network for my laptop?
Can anybody throw some light here please?Thanks!
I really need some help. This is what I'm trying to do: first of all, i have a PC running Vista. Now on that PC, i have a virtual machine using VMWare Workstation 6, which has Win XP with SP2 installed on it. On the virtual machine, i have Visual Studio 2005 and SQL Server 2005 Express Edition with SP2; now, the thing is, i have a program in C#, which is supposed to connect to a network, but since I'm running on just one PC which is not connected to a network, i instead connect to 127.0.0.1 via port 1433. Now here's where my problems start. At first, i could not connect because i kept receiving an error which said "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. (provedier: TCP provider, error: 0 - No connection could be made because the target machine actively refused it.)". A friend of my mine helped, so i did the following: i went into SQL Server Surface Area Configuration (configuration for localhost) , changed the remote connections to allow for both local and remote, using both TCP/IP and named pipes, restarted the database engine, started the SQL Server Browser; then i went to administrator tools, Data Sources (ODBC), and from System DSN tried to add an SQL Server. I gave it a name, and on the server textbox i tried typing "localhost", but doing so, i could not get past the next screen, (i did specify the port as 1433) where i have to chose between win nt and sql server authentication, and neither would work (even though i know the sa password and can log on to SQL Management Studio using that password). Then i tried copying the server name from the management studio, as the server when trying to add the system DSN. That seems to have worked, and i finished ading the SQL Server to the System DSN, using the database which i wanted. But after all these steps, i still get the exact same error as before - "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. (provedier: TCP provider, error: 0 - No connection could
be made because the target machine actively refused it.)".If someone can please help - i've tried everything i can think of - i can access the internet from the virtual machine, i even tried disabling the firewall, but no luck. Is it because of the virtual machine? If so, can anyone suggest a solution? I actually doubt it, because i've even tried to install it on my pc, not the virtual machine, so on vista - and also installed SP1 for VS 2005 and SP1 for Vista, but still the same thing. Sorry for making this post so long, but if anyone can help, i'd really appreciate it. Thanks!
Say I have 2 servers clustered for SQL. xxxP1 and xxxP2.
Can my SQL virtual server name be xxxP1 or does it have to be something other than the names I called the 2 W2K boxes.
Thanks..
Good morning,
I am looking for some first-hand experiences from fellow DBA's where they had SQL Server running on a Win2K3 VM. What sort of issues (or successes) did you find re: resource sharing, swap files, etc? Are there any experiences where using a VM negatively affected your environment?
Thanks so much. What a great forum!
I have two instances of SQL Server running on my Development machine.I am having some performance problems and while investigating theproblem I saw with the Process Explorer form Sysinternals that bothinstances consume each 800 Mbytes of memory!I experimented with sp_configure and by giving both instances a fixedmemory size. Both methods do not seem to have any effect.Can anybody explain me why SQL Server is using so much memory?Thanks for any information.Evert WiesenekkerPSBesides the northwind database I only have one simple extra database(70 Mb in size) installed.
View 2 Replies View RelatedI have a 2 part question about adding a new 'named' Virtual Server to an existing Clustered SQL Server 2000 install.
I have a 2 node MSCS Cluster (WIN2K advanced Server sp4) with a default SQL Server instance. This has been in production and working fine. I created a new Cluster resource and reran SQL Server 2000 ENT setup and added a second Virtual SQL Server (named instance). After many problems, finally got the second Server installed. Now I have 2 SQL Server instances in the Cluster - from what I understand, you can have up to 16, each seperate installs with seperate Cluster resources.
Thus the problem:
For the Second Instance, I have specific instructions from the Applications vendor on how to install SQL Server to work with their APP. I need install SQL Server WITHOUT the Full Text Search component and WITH a specific Server Collation (Binary order for use with the 850 Multilingual character set). (I have done this same setup on standalone SQL Server installations for this APP and they have gone smooth).
When I installed the new Virtual 'named' instance in my Cluster, I Could NOT 'DESELECT' Full Text Search when I choose Custom install.. it does not appear as an option???
Also, I chose the "Binary order for use with the 850 Multilingual character set" during the installation, but that is not the Server Collation that is installed...
I have already installed SP3 for SQL Server against the Virtual Server on this Cluster, as well as a HotFix... and Now I'm thinking I need to rerun the SQL Server installation, uninstall the second server and reinstall to see if I can fix the 'Collation problem' .. but I'm not sure if this is the right course of action.
Does anyone know why I cannot 'deselect' Full text search component at install, and any ideas why it did not install with the SQL Server Collation that I specified at install????
Hi,We have a prod server running on SQL server 2000 64 bit. It is a4cpu server with 16GB of RAM. we have a maxmemory setting of 15.5GBfor sql server. Inspite of 15GB being available for sql server, itstill uses paging file space, a lot. When looking thru task maanger wecan see sql server using 15.5GB of Memory usage and 22GB of Virtualmemory usage. I don't understand why it should even be using closer to7GB of Paging space, when it has so much memory. How does SQl serveruse Virtual memeory vs Physical memory?HAs anyone seen this before.ThanksGG
View 2 Replies View Related
Hi,
Can I Install a default instance on Virtual SQL Server on a 2 node Cluster. If I already have a default instance on a different Virtual SQL Server on the same clustered Server.
What i am trying to do..
if i create 2 virtual sql Server (say sqlVi1 and sqlVi2)..
i want o connect using sqlVi1 and sqlVi2..not Sqlvi1 and SQlvi2Namedinstance.
If yes..How can I do it?
Thanks in advance
I Hope someone from Microsoft or MVPs will help me.
if this is not the corrcet forum...please point me the correct one
We need to move a cluster to a new data center. There is a strong preference to retain the previous SQL Virtual Name. The existing cluster has a single default instance. We understand that when you have created a SQL Server FCI that you can change the SQL Virtual Name but not the instance name. So if the current SQL Virtual Name is SQL1 then at a high level:
Build cluster at new DCInstall SQL Server FCI with a virtual name as SQLTEMP and as a the default instanceShutdown old cluster ???Rename SQLTEMP to SQL1 Since there is an existing SQL Virtual Name my concern is that we cannot simply rename SQLTEMP to SQL1. Do we need to delete the VCO from AD for SQL1 in step
I have been tasked with moving our SQL server estate onto new 64bit SQL 2008 Virtual servers on a VM base. Each Virtual server will be attached to our SAN that i will have no control over. Do i ask for multiple LUNs pretending that there is a COS), Etemp), FData) and Glog) disk structure or do I just present a very big space as a single C: drive and let it go.We are consolidating lots of old physical servers onto fewer (more powerful) virtual servers (according to the VM and SAN administrators)
1. Configure your SAN properly
2. Don't overallocate shared resource