One DB Machine For Two WebSites
Jul 13, 2007
When there is 1 DB machine for 2 web sites, is it better to have
One DataBase-instance running with 2 DataBase-Initial-Catalogs ?
or
Two DataBase-instances running, each with 1 DataBase-Initial-Catalog ?
using SQLExpress or SQLServer
please only look at those possible, simple conditions.
forget about read/write same tables, security issues..
Interms of Memory/CPU/ Performance, which setting seems better ?
Please give some thoughts on Performance / DataLoad / Consumption,,,etc...
thanks.
View 4 Replies
ADVERTISEMENT
Mar 15, 2006
Hi there, i was wondering if there are any performance issues involved with having two websites using one SQL2000 database. Both the websites need to update, insert and select from the single Database. I was hoping to get any comments / views that you may have.
Regards
View 1 Replies
View Related
Jun 19, 2007
I am dealing with an old ASP.NET 1.1 web app that I want to fix and
update. The existing site has an SQL database on the web host's SQL
server. I want to rip a complete copy of this database (it isn't large,
only 9MB) onto my desktop computer, so I can alter it and "bench test"
the changes I'm making to the overall application in VS2005.
Now, I have tried to yank a copy of this database and its structure
using GUI programs like Visual Studio 2005, SQL Studio Manager Express, and EMS SQL
Manager, none seem to offer a "Save As" option. While I can easily make changes to the database and its tables
on the web host's server (sql.hostname.net) with no problem, I can't
figure out how to pull a copy off of their server and onto my machine...
Does this problem have a very simple solution that I am overlooking?
Thank you for any advice!
View 1 Replies
View Related
Dec 27, 2007
If I create a website in VWD express and create a database in the APP_DATA folder it works great. Then if I attach it in SQL Management Studio, when I go back to opening the website I get MyMachineaspnet can not log into database. Even if I copy the database.mdf file of a working site to a different folder, rename it, attach it. The original website fails to open the original database. With out changing anything. If it's a DNN website it returns Website currently unavalable. After this happens I can in VWD open and see the tables in the database. I think databases created in the APP_DATA folder in VWD are "User Instances" I don't normally see them in SQL management Studio. Something about the Studio breaks them.
This is getting old real quick so PLEASE tell me what am missing here. Thanks
-KK
View 2 Replies
View Related
Dec 19, 2007
Hi, I have installed reporting services on 2 servers now and each time I click: "Report Server Virtual Directory", "Report Manager" "Virtual Directory" or "Web Service Identity" in the Reporting Services Configuration Manager I get the following error:
"An error occurred while enumerating the websites on "SERVER1". If "SERVER1" is a remote server, try changing the firewall settings in the operating system to allow the enumeration. The exception details are: Library not registered.
After this I cannot change any settings under these configuration items.
The servers I have tried installing are running Server2003 R2 SP1 x32 & x64.
I have tried changing service accounts, reinstalling IIS, reinstalling Reporting Services, changing website permissions and IIS configuration but I keep getting this same error.
The server is not a remote server nor is there a firewall present. As the error states there is a unregistered library but I don't know which one.
Thanks in advance.
View 2 Replies
View Related
Jun 18, 2007
I'm trying to create a website based on interesting historical facts, Searchable by date. I need each fact entry to have a datetime field in the database, but unfortunately this method only lets me go as far back as the year 1753 (for an inexplicable reason, I can go up to the year 9999).Is there something I'm overlooking here, or did Microsoft goof this one? Will I have to store my dates as 3 separate custom month/day/year fields? If anybody has a solution for this, please let me know (a B.C./A.D enabled solution isn't at all needed, but I'm open to that too).
View 1 Replies
View Related
May 4, 2007
Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as
Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )
The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Thanks!
View 4 Replies
View Related
May 30, 2008
Just installed SQL Server 2005 and tested my old VS 2005 ASPnet websites, which were connected toSQL Server 2000 databases before. All my websites were created for local HTTP applications, coded with a connection string with User ID and Password. The SQL Server 2000 was configured as mixed authentication (i.e. with User ID and Password). These websites worked very well with SQL Server 2000 database server.Testing my old VS 2005 websites with SQL Server 2005 database, showed a 'Login failed for a User ''.' error msgalthough the 'Test Connection' on VS 2005 design showed a perfect query for e.g. a GridView control. I have assured that the UserID/Password were correct for Management Studio Security object'slogin and Database Security's user. The server instance was configured with mixed authentication mode. One thing I am not sure of is, when clicking the Management Studio icon, a Connection dialog showed up, asking for a Windows or MIxed authentication? I just stayed with the Windows authentication. What does the authenticationmode have anything to do with the VS 2005 website connection? Should I change to mixed authetnication mode?TIA,Jeffrey
View 3 Replies
View Related
Nov 28, 2006
Hi All,
I have enterprise version software CD1 and CD2 of SQL server 2005
when i try to run setup.exe..the following error pops -up
The image file Setup.exe is valid, but is for a machine type other than the current machine
MY OS version is windows 2003 32bit Operating system...
I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software
Thanks for your Help
Mohan
View 4 Replies
View Related
Nov 16, 2006
Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
View 2 Replies
View Related
Oct 2, 2000
Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...
View 1 Replies
View Related
Jul 23, 2005
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
View 1 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from login:passw@machineb.dabatase.dbo.customers
thanks!
View 2 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from loginassw@machineb.dabatase.dbo.customers
thanks!
View 6 Replies
View Related
Oct 23, 2006
Hi,
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
From "ServerMachine" or from "ClientMachine"
Thanks
View 3 Replies
View Related
Jul 13, 2007
Hi Guys,
I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.
Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.
So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?
It would be great if someone can show me the links to kb article. Thanks
View 1 Replies
View Related
Jun 30, 2006
Dear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
View 1 Replies
View Related
Aug 30, 2007
Can we have Reporting Services having its database on a server and distribution server (http://IISserver/Reports)
on another server?We dont want our database server to have IIS and dont want SqlServer installed on our IIS server
kind regards
View 4 Replies
View Related
Jul 11, 2007
Hi
I'm trying to set up replication from one SQL server to another.
The publishing server is not a member of a domain and is located in a hosting center (but we have full control over the server). I can set up a Snapshot publication just fine.
The subscribing server is located in another remote location and is a member of a domain. Here I can also set up the subscription without errors.
The errors, I think, comes when the snapshot is about to be created, the error is, on the publisher server:
[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [SQLSTATE 28000]
And the snapshot is not created.
Is it even possible to set up replication like this. I need to transfer the data from one sql server to another so we have a working "backup" so to speek if the other server does not respond.
View 1 Replies
View Related
Jul 17, 1998
I have SQL 6.5 running just fine on my development server and 6.5 on my production server (which I will not tinker with) but I create summary tables on the development server and transfer them to the production server, this is what I do not want to damage. But, I want to know if I can install Beta 3 to run concurrent with 6.5 or somehow operate 6.5 from 7.0 without damaging the ability to restore 6.5 databases and transfer summar tables to another 6.5 server. I`m asking this because monthly I get a database dump, restore it on my side, do my hashing of the data, and then transfer summary talbes to another server where it`s available to be queried from the web with Cold Fusion.
Please let me know.
P.S. I have 7.0 beta 3 running at home and found that it had removed to 6.5 application group, but when I start 7.0 manager it shows the 6.5 server but I cannot access it for some reason. I didn`t upgrade any databases.
View 1 Replies
View Related
Sep 7, 2000
I want to know if there are any issues installing SQL 6.5 and 7.0 on the same server? I know that it can be done and that you cannot have them both running at the same time (at least if you're trying to use the default IP port). I just want to if there are any consideration other than just running the install normally. The server already has 6.5 on it and I want to add 7.0 to it.
--Buddy
View 1 Replies
View Related
Jun 4, 1999
I noticed one of the other messages said it was O.K. to put SQL 6.5 & 7 on the same machine. But, are there any issues/concerns that should be addressed before this is done.
View 1 Replies
View Related
Feb 15, 2006
hai i want the name of the system which executes a SP in sql server is it possible. by using this i can log data by keeping this request is done by person from this machine.
is this possible.
Any one help me.
Thanx in advance.
View 6 Replies
View Related
Jul 20, 2005
Hello,I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machinewith 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.I do NOT load the DB in any way with queries. Obviously this leads toall kinds of software not working well anymore. Does anyone know how tolower the CPU power used? Please help!?regards,Pierre VerbakelThe Netherlands
View 3 Replies
View Related
Apr 21, 2008
can we install SQL Server 2005 x32 and SQL Server 2005 x64 on same machine with Windows 2003 Ent x64 OS?
many thanks
View 5 Replies
View Related
Feb 22, 2004
Hi,
I have developed an application using SQl Server 2000.
I want to transfer the database to my new server. I want all the tables and datas to be transferred.
I am new to this application. So i am not able to get mysel started. Can someone help me in this problem.
My database is large. It has stored procedures, database diagrams.
Any help in this regard would be highly appreciated.
Thanks,
-sriram
View 6 Replies
View Related
Jun 14, 2005
Hi,i have developed an web-database enabled application, wherein the admin will be importing the data from a remote machine to the server.Is it possible to run the DTS remotely? Also, is there need to install the sqlserver in the remote machine on which the admin is working ? i mean to say, other than server, do i need to install sqlserver on the remote machine too..Thanx in advance
View 9 Replies
View Related
Feb 23, 2001
Hi,
I have to buy a new machine for SQL 7.0/NT.
I know the db size it's going to have.
How can I get what machine configuration I should suggest.
I mean...what should be the RAM/HDD size/etc..?
We are expecting around 40hits/day?
Anyone have any idea?
Please suggest.
Thanking you.!
View 1 Replies
View Related
Aug 4, 2000
i want to a backup a database on a different machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.
any suggestions plz!
thanks.
View 4 Replies
View Related
Aug 7, 2000
Hi,
i want to take a backup a database which is on a different machine to my machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.
Anyone could tell me how to do it step by step plz.
Thanks.
View 2 Replies
View Related
Oct 11, 2000
I am trying to open some DTS packages from another machine, I see the list but when I try to open one and I get the error: The Parameter is incorrect
I have look at permissions and everything looks good. (I can view about 2 out of 20 packages all packages have the same owner.)
Any would be great.
Thanks
Jacqi
View 1 Replies
View Related
Dec 27, 1999
Hi:
We have DTS packages that are scheduled to run on the 1st of every month. Our clients have decided to turn off their machines on the 31st of December. What will happen to the scheduled packeages when the machine is turned back on?
Is there a queue they are put in so that they'll run when the machine comes back up OR is an alert generated and the package scheduling automatically sets the execution for next month??
We are running MSSQL 7.0 SP1 on NT 4.0 SP5.
Any replies will be greatly appreciated.
Thanks,
Nishi
View 2 Replies
View Related
Aug 17, 2000
I am migrating a web server which support two web sites ( with 2 IP addresses). Both the sites have a database associated with it. I am sure one of them is using SQL 7. Now I was told that the other is using SQL6.5. I know you can have both SQL6.5 and 7 on the same machine. But can you get them running at same time? Any feedback is greatly appreciated.
View 4 Replies
View Related
