I've a problem that I haven't experienced before and need some help. I've developed an app that works fine locally and have uploaded via FTP to my host provider - .NET 2 and SQL2005 Express.
I'm now getting problems accessing the site. In the application load event I load a couple of application state items from the database. When it hits the default aspx page, it throws an Object reference not set to an instance of an object. error because the application state items haven't been loaded. The host then tried to load the database using SQL Management Express to ensure there wasn't a problem with the database and this is where I get confused.....
When they try to attach it, the message column n the "Attach Databases" screen says the file cannot be found. In the "Current File Path" column, it points to the path of my local machine, i.e. H:SourceClubApp_Dataclub.mdf. This leads me to believe that somewhere in the database the original file path is noted and used. I can't find this and wondered if anyone has come accross this issue before?? The log file has been deleted.
Dears,I have devoloped an application ASP.NET 2.0.Before I have builded the aspnetdb throught the command then I built some tables and stored procedures on this db. (My db is sql express 2005 and my hoster db is sql 2005 workgroup)My hoster doesn't allow connection Management studio express, doesn't allow attach or restore functionalities.Than I have built my script db (contains Tables, Views and Stored Procedures), I have substituted the dbo with my user account in the script because my hoster doesn't allow the dbo access.I have also transfered my site files (.aspx, img, etc.) on the server.When I try to access the db I receive this error (for example when I push on the button create user):The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. Please could you help me? Thank you.
What can be done if the shared web hoster I am using allows only 1 sqlserver database and a second web application I would like to install isconfigured to use its own database?can databases be nested, one within another?thanks,-Steve
I have an sql script that I ran on my local system using osql. Itcreated all the tables, views, and even inserted sample data into thetables.Now I need to create that same database on a shared hoster site. Onlythe hoster does not allow the running of osql.How can I create my sql server database on my shared hoster site?Can I save and restore my database somehow?Is there a stored procedure I can run which will run the .sql scriptfile?thanks,-Steve
I have a question and bear with me because I am pretty new to this topic.
I have a SQL SERVER 2005 with a Client Server Application. Now I want to add a Webinterface. Sinice there is no infrastructure for hosting our own server. I want to go to an external hoster/provider.
Now my question is it possiple to replicate a snap-shot of the database to an web hoster?
If yes, what does my hosting package requieres beside SQL SERVER and ASP.NET. Any Services and open ports? What about Security?
When I replicate via push Service from my local SQL SERVER do I have to have a tunnel to the provider? Or external network access to my network via VPN. Or is there a way of doing it via HTTP? HTTPS? (I think I saw some settings about FTP replication...). Because of the Infrastructure Problems mentioned above...
It would be great if someone could give me closer information about this topic...
Links, Ressources, Tipps, Tricks, Tools... just anything... would be appriciated very much...
I have been creating applications using SQL Express and uploading them to my hoster. No problems there. Now, I feel I'm ready to the next step and would like to start using my hoster SQL Server. I have created a database in their server, now how do I move my created SQL Express Database to their regular SQL Server? Is there a way to run a tool against my local DB and create a script to run in my hoster? What is the best practise here? Your help is appreciated.
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?
I am unable to install 32-bit SQL Server Integration Services on the server due to something that was left behind by the 64-bit version.
I've uninstalled SQL Server 2005 64-bit and when I try to install the 32-bit version of Integration Services, I get this error: "Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error descrition: FATAL: Could not find component 'Microsoft.SqlServer.Dts.Task.MessageQueueTask.ServCompMQTask' we just installed."
I can't seem to figure out how to resolve this problem with the COM+ and I can't remember if Integration Services is required.
here's my prediciment, I need to transfer my SQL DB to another SQL Server, but I don't have access to the server, I get the login through a third party company.
So what do I need to do to transfer the database to another server as an EXACT copy of my original database, IDENTITY Fields and all.
Hi all, How do I transfer a database from a SQLEXPRESS instance on my PC to another SQLEXPRESS instance on my laptop? I tried backing it up and restoring it on the laptop but it comes up with errors. This is the error Restore failed for Server 'DOUGYDOESQLEXPRESS' System.Data.SqlClient.SqlError: CREATE DATABASE permission denied in database 'master' (Microsoft.SqlServer.Express.Smo). Do I need to perform some configuration somewhere? Any leads will be most appreciated. Thanks
How will I be able to transfer table that have stored procedured specifc to them to another server? This is from sql server 7 to another sql server 7. Would this be possible without losing any data or procedure or which ever may be attached to the tables?
Is there a utility to transfer the logins for a database for one server to another without setting the login passwords to null as the SQL transfer utility does?
Really easy question I think. I've been working on a website using a back end SQL database. All the tables, views etc have been designed and built. There is some data in the tables. Now that I have developed it I want to move the whole database onto the live Server which resides on another machine. How can i transfer a database from my development server to the live one?
I have two SQL servers I am dealing with. I have some tables in one databaseon one SQL server that I want to transfer into a database on the other SQLserver. I want to xerox copy the tables including all primary keys,identities, defaults etc. I used the export/import feature in EnterpriseManger, but when I do it, and view the tables that got imported, all of mydefaults are gone and all the primary keys are gone. What is the best way tojust copy a few tables from one database to another. I do NOT want to copythe entire database from one SQL server to the other, only a few tables. Ijust want to make sure that when they are imported they are exactly the sameas where they came from. THANKS
I am having Access database in my local system . Values in the access database will be updated for every 5 min . I am also having Sqlserver database online with the same structure database of Access in my local system . What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
I need to create a stored procedure that copies records with DeptID = 'S' from Table1 into Table2.Is there anywhere i can check up information on how to go about doing this or the SQL syntax for this?
Hi I need to copy all the jobs from one server to another server. How i have to do. I tried to take script of MSDB database, but it is not scripting all the jobs. PLs anyone suggest me what i have to do with scheduled jobs in 65. it is very urgent pls. thank u --Rk
I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server. I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?
i ave transfered all the users from one of my sql server to another sql server but what the problem is that all the users that are on new sql server having a NULL password.....
so that means that when u transfer users from one sql servers to another the passwords will be remain as null for all users......
I have a SQL Server 2000 database in a remote host and I want to move all my data to another remote (virtual) host, where on both machines I do not have direct access.
Can you advise me what is the best way to make this transition?
I have an application that runs off an sql server 2000 sp3 database. I have taken a backup (.bak file) of the production database and restored it to another server for testing purposes. the users cannot login to the new server because the logins have not been transfered to the new server. I am looking to transfer the logins using the procedure outlined at the following link: http://support.microsoft.com/kb/246133/ under the header "Create and Run Stored Procedures in the Master Database". what I need to know is will this procedure affect the production server in any way? (I can't have that) and is there anything else I need to do after this to let the users login to the test server with the same name and passwords?
I have created two SSIS packages one is development and another is test. I used near about 15 global variables in my test SSIS package.Both development and test package working on transfering data from database and put into text files now i want to implement all these variables into development package how i will do that wheather i have to create all these variables in development package also or there is way to transfer these variables from one package to another
When restoring DBs to other environments the SIDS don't transfer causing access problems, and when I use a SID scripting method and deploy on the target environment SQL says the login already exists.
I usually end up with the cumbersome process of explicitly removing the logins and re-applying - how to other DBA's get round this?
Hello all,I am currently working on upgrading the old website to an asp.net website.Current website uses flat-files as its database, so I need to convert a few files into SQL tables.The file that I am having difficulties with has the following structure (tab and coma separated):OrderID CustomerID ItemNO1 1 1,2,3,42 1 5,6,73 1 4,5,67,4576A,234 2 4,56,678,DF23,75 2 78,2,567,4556,3,45,FG456 3 2,45, F35 etc.... and I need my table to be structured like this: OrderID CustomerID ItemNO1 1 11 1 21 1 3 1 1 42 1 52 1 62 1 7.......................The import function in SQL database will not do this. Is it possible to automate this somehow? Thanks
Has anyone had a problem transfering a database to a server. This is the first time I have done this. I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database This is what I'm doing
From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next". In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next". Note: You can also use Windows Authentication if the SQL server is a local server. In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next". Choose "Copy objects…", click "Next". Uncheck Use Default Option. Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions". Leave next window as is, click "Next". Click "Finish".
It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info. Can anyone help me out