hi everyone.
i am working on 2 instances of sql. I want to do a queries and selects with this 2 instances in a single page. How could I do that?
For e.g. assuming the name of the instances are A and B...
thanks
RON
________________________________________________________________________________________________
"I won't last a day without SQL"
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance.
View 4 Replies View RelatedI had a server with SQL Server 7.0
I installed a named instance of SQL Server 2000 and then i passed all my DB
of the 7.0 instance to the 2000 instance.
Then i removed the 7.0 instance, that was the default instance.
So at the moment there is only the 2000 version, but it isn't the default
instance
Can the 2000 instance become the default instance? (So that clients can
connect to it simply through computer name, and not creating an alias)
thanks
Fede
Hi,
Can anybody tell me..which command should i use to get the list of all the server names, all the sql server instances in each server and all the databases in each sql server instance.
Why do people have various instances of SQL Server running on 1 box , why cant we have various databases running for 1 instance
Whats the advantage of multiple instances
Thanks
I have a server running one instance of sql server enterprise edition. I want to install an additional application that requires sql enterprise edition. Can I install sql enterprise an create another instance for the new app. I know that I would have to give it's unique instance name.
Thanks in advance.
Hi every1. How can i know all the sql instances installed in my local machine?
Thanks.
RON
________________________________________________________________________________________________
"I won't last a day without SQL"
Is it possible to change a 'Default' instance to a unique name?
Am thinking I shouldn't have to re-install SQL 2005?
Hi,Is it possible to install more than one instance of SQL on the same server?I am thinking of the SQL that comes with Windows 2003 SBS (Small business)--Thank youPlease post only
View 2 Replies View RelatedHi,I am pretty sure that the answer to this one is a simple "no", butthought I would check anyway...If I upgrade a SQL7 server to SQL2000, leaving the SQL7 instance asthe default instance on the new SQL2000 installation and install anamed instance of SQL2000 -- Can I at a later date, make the SQL2000named instance the default instance and remove the old SQL7 instancealtogether?Many thanks,Colin
View 1 Replies View RelatedHow to see the no of instances created for my server.
View 4 Replies View RelatedHi Dears, How can i detect the Local SQL Server instance (server name, uid, pwd) installed in a standalone systemusing C# 2.0?I used the fucntions available in odbc32.dll, but it only returns the result while the systemis connected in network.can any one resolve this....?thanks in advance...yenkay
View 5 Replies View RelatedHi. I am trying to connect to a database but keep encountering the same error. I have a free hosting account with quantasoft (qsh.eu) who fully support SQL express user instances. I have also used the connection string generator on their site. This is the result of the error.
Cannot create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted.Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'.File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted.Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'.File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Cannot create file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.
Could not open new database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'. CREATE DATABASE is aborted.
Cannot attach the file 'H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf' as database 'transmission.qsh.eu_a45add63-33a4-4414-b09c-6880f10717b3'.
File activation failure. The physical file name "C:Documents and SettingsJamesLocal SettingsTempVWDWebCacheftp_transmission.qsh.eu_wwwApp_DataDatabase_log.LDF" may be incorrect.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.WebControls.Repeater.GetData() +50
System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232
System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
System.Web.UI.WebControls.Repeater.DataBind() +72
System.Web.UI.WebControls.Repeater.EnsureDataBound() +55
System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
------------------------------------------------------------------------------------------------------------------------------------------------------------------
When i remove the database= tag i get this
An attempt to attach an auto-named database for file H:HomeWebsqsh.eu ransmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009wwwApp_DataDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i have sql server 2005 express running. during install, i had issues with a system dll that i found answers online and resolved. i am still very green, but i know much more now than i did at the time. i believe that as a result of the partial then failed installs i have multiple instances either fully or partially installed. when i am in the sql server mgmt express environment, it lists two sql engines. i only ever use one, and would like to safely remove the second without damaging or corrupting anything done with the other instance.
my reasons for wanting to do this are twofold. first, i would like to free up the drive space taken up by the second instance. (i am a stickler for clean harddrive mgmt and maintenance). second, now that i have used the software and am somewhat more familiar with it, i would consider installing a second, intentional instance so that i may attempt to better customize some of the install-time settings and configurations.
can anybody give me any pointers/ guide me in the direction of information on how to SAFELY go about this?
thank you in advance for any help.
I created a second SQL2000 instance on a Windows 2000 server. The strange thing is that I can create an ODBC connection to the default instance but cannot for the new named instance. If I try from a client that has SQL installed on it, I can see both instances. Any idea why this is happening?
Thanks,
Ken Nicholson
Is it possible to rename a named instance?
We have a vendor product that can only handle up to 18 characters for the server name and the instance name (we did not know this when we created the named instance) and of course our combined name is 19 characters, so it trys to pass the 18 charater name and then fails with the following error:
[LOG] Unable to read local eventlog (reason: The data area passed to a system call is too small)
So, can i rename the instance, or do i have to create a new named instance?
Thanks
with sql server 2000, it is possible to have multiple instances on one server. Now I want to make the second server a subscriber for specific tables before there are some tests/major changes. Has anyone experience with this on the same server. Note : sql server subscriptions between different servers in sql server 7 is not the issue.
View 1 Replies View RelatedI created a named instance of SQL Server 2000 on my notebook. I inadvertantly set the trusted SQL connection to Windows Authentication. This is creating a problem with COM because of username and password. I want to reset it to use SQL Server authentication but I can't find where to do it. Can I do this or do I have to delete this instance and create a new one.
View 1 Replies View RelatedWe're trying to decide if we should use a single large instance of SQL Server or multiple instances on the same server. This is for a dev environment.Have to limit max RAM per instance so no instance grabs it all.There will be I/O contention and CPU contention between instances since the different instances won't coordinate with each other.It limits the available RAM for In-Memory tables..It sets lower limits to the amount of RAM available for any given query, causing artificial "contention" even when there's nothing else running at the time.
View 2 Replies View RelatedMy issue is that: here have two datamirror servers, and when the first fail, mirror needs to assume with the same name.
I'll try explain: SD01 - Primary, SD02 - mirror. If SD01 fails, SD02 assumes called SD01. By the way, the instances are in same domain, but not in same computer.
Hi Gurus,
What process i should folloew to ctrae instance on server.
Thanks,
ServerTeam
Can someone explain what "named instances" means with regard to SQL?
Is this one Physical Server With multiple installs of SQL SERVER and / or databases ?
We have a list at my small comapy with "raw sql 2000 database instances". Can someone help out, I'm getting conflicting info!
Thanks,
Scott M
Hello,How to determine, which ports do MS SQL Server instances listen to?I want to conect to sql server using PHP and I need to know exact portnumber. I suspect that my SQL (msde) server instances don't listen ondefault 1433 :]--Stefan
View 1 Replies View RelatedCan anyone suggest a method of enumerating instances of MSDE 2000 withoutusing DMO ?Using C++, MFC, and ADO.Thanks
View 2 Replies View RelatedDear SQL Guru,I just found out this morning that my SQL Server box had been added 1more instance. Below is the example:PPAPP0075FINANCE (Old instance)PPAPP0075ACCOUNTING (Old instance)PPAPP0075Accounting (new instance)This is a case sensitive MS Sql server (third party vendor App). TheACCOUNTING instance is the one we have been using for our currentapplications. I found out the new one(Accounting) when I scan thenetwork by using OSQL -L utility. However, when NT engineers tried toverify the physical files location ofAccounting, and it did not exist. When I tried to register it and itdoes not appear from Enterprise Manager.Please keep in mind NT Engineers have been monkey around on this serverquite a lot in last a few weeks, especially modifying Registry keys.My question is, where did PPAPP0075Acounting come from? We never evertried to install any more instance on this server.Please help,Thanks,Silaphet,
View 1 Replies View RelatedSQL Server 2005 SP2Are there any guidelines/rules of thumb as to the max numberof SQL Server instances on a single 64-bit server?thanksaj
View 1 Replies View Relatedconfig - 2 machines in a workgroup, service running under local system account. Tried the following config. from Rushi. Running profiles on both machines. on source - starts the conversation, and a send. then get an event subclass 2-remote at a periodic interval (in a loop), no activty on the other end. any suggestions
View 3 Replies View RelatedI have been developing and testing my app for some time without worrying about the question of user instances. Due to the nature of the app, I would want the database to be copied to laptops, where data would be added and then merged back into the "main" DB.
To facilitate this, when the (VB) app first installs, it copies the DB files from the data directory to an easily accessible folder which it creates in the C: drive (if they are not already there - to facilitate application upgrades).
The code is written and working. However, then I thought about user instances. With User Instance set to True, I suspect that this concept of a DB file created by a user on a given machine being readable by another user with a laptop is likely to fail (unfortunately I only have access to a single machine).
So I tried to change the User Instance to false (in the App.config file). This stopped the application from running. I checked in the Modify Connection (Advanced) screen which still showed User Instance to be True. I tried to change this but got an error message.
I can see a way around this, but I don't like it. I guess, rather than "export" the DB files to the laptop, I could send the data as an XML file. However, this seems to me to compromise security as it would be very easy for anyone to filter any actual data they wanted from such a file - unless there is a way to password protect an XML file?
So, is there any way that I can make these DB files (on the C: drive) available to any user, on any machine who is running the application so that they can import the data to their version of the App, add to it and then send the changes back to the original?
Thanks,
Rich
According to the Task Manager, on my SBS 2003 Server, I'm running multiple instances of SQL. How do I determine which instance(s) are required to maintain server stability, and which are not. My Server resource use continues to be a perennial problem. Please advise.
View 3 Replies View RelatedA small question which may be stupid.
In Management Studio Express, one instance of Sql Express is running, with User Instances. This in indicated by a green circle with a white arrow head.
At the same time I'm connected to an instance of Sql Express on a Small Business Server. This server instance just has a white circle, but is also running. Is this normal.?
Tailor
Hi all,
I already have a copy of SQL SERVER 2000 installed on my current local machine.
How is it possible that I create another second instance for example TEST/silkkeng in SQL Server Enterprise Manager? OR SQL query ?
Is it possible ? Or the only solution is ReInstall SQL to create another instances?
Hi,
So if the connection strings for say 2 separate users is configured for a user instance, what is the best approach to synchronising the user instances against each other and the Server instance?
This architecture suits remote users and I'm very interested to learn more about it.
Cheers,
John
I recently took the plunge into SQL with a CRM installation on the default instance of a SQL Server 2005 (SBS Premium). I am now adding accounting software and prefer that it use SQL 2005 as well instead of Express. My understanding is that I need another instance. Am i correct? How do I create a new instance?