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
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?
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
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.
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).
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
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
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
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.
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...
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
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
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
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"
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
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.
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.
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.
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.
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.
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
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
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.!
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.
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.
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??
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.
