Problem When Trying To Deploy A Web Site Built With Asp.net 2.0 And Using SQL EXPRESS
Jun 6, 2006
Hi,
Plz help!
I built a web site using IIS and ASP.NET 2.0.
My web site has a log on screen and I only configured it with one user without any roles. This web site uses the SQL EXPRESS.(I Have 2 databases: 1 for the security required by the application and the other for my application. for the connectionstring I used a windows authentication security with an instance = true.)
Everything went well on my PC.
When I tried to deploy the web site on another PC, there was a big problem.
When I tried to login with the same user I created, then I have a problem.
The password is incorrect(Why? I don't know).
Maybe there is a problem with the IIS or with the SQL SERVER.
pLZ HELP!!
View 1 Replies
ADVERTISEMENT
Nov 7, 2006
I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.
When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:
Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.
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: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error:
Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text))
Line 144:
Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 146:
Line 147: dl_Description.DataSource = dataReader
Source File: d:hostingcurraheepxdefault.aspx Line: 145
Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.
This is the Stored Procedure:
CREATE PROCEDURE [dbo].[sp_GetItemInfo]
@str_ItemName VarChar(50)
AS
SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color
FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID
WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName)
ORDER BYtbl_LookupSizes.str_Size
Does anybody have any suggestions as to why this stored procedure is failing?
View 1 Replies
View Related
Nov 3, 2005
hi all,
Can any one clarify me the doubt in deploying the application build with SQL Server Express 2005 as database and Vb.Net 2005 as frontend with the same setup made for delopying application. will the server installation and database creation can be made automatic.
If this is possible then what are the steps in doing so and the files to be included while enbeding with vb.net setup.
thanks
harsh
View 2 Replies
View Related
Jul 21, 2006
Greetings,
I think these should be rather simple questions, yet I spent a number of hours last night digging through the forums here and msdn and couldn't find any satisfactory answers. Basically, there tend to be types of information that are commonly saved in most databases, like names, addresses, phone numbers, email addresses, etc...and there are a variety of built in data types in SQL Server. What are the best built in datatypes for some of the common entries in a sql database. Also, there are a number of character based types and I am curious why one would be more useful in certain situations than another. Why is there char( ), nchar( ), varchar( ), nvarchar( ) and text datatypes? Why so many? Also, what is the "text" datatype and when is it most likely to be used? There is very little about the text type that I can find in the msdn or SQL Server docs...aside from the fact that it's text. On top of all this, there's numerous binary types as well. I'm really not getting the reason behind all these different basic types and why I would want to use one over the other in any specific instance.
TIA,
Mark
View 14 Replies
View Related
Aug 15, 2006
When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.
I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.
As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.
I've tried:
SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM
SQLACCOUNT=BUILT-INSYSTEM
etc.
and even some different SID as:
S-1-5-18
S-1-5-19
All with no password with the SQLPASSWORD parameter:
SQLPASSWORD=
I still getting the same error while validating the service account.
Is there someone else who knows what I'm doing wrong?
Best regards,
Mattias
View 5 Replies
View Related
Apr 13, 2006
I've built my SQL Server Express database with SQL Serevr Management Studio Express, and now I want to enter some seed data to assist in building tha app around it. I cannot find an option to manage the data in SQL SMSX, like I used to with Enterprise Manager.
I don't want to have to write an app just to get test data in. Seems like this should be a common need. Am I missing something obvious here? Can't find any reference to this in a search of the forums.
Please help.
View 1 Replies
View Related
Jun 28, 2007
Hello Everyone,
I have developed an application in Visual C# Express Edition, that uses a SQL Server Express database. I am deploying it using ClickOnce, and I'm wondering if there are any settings I have to change to SQL Server express, in order for my application to be able to access the database, since I'm getting an error when I start the application. I consider myself a beginner developer, so please take that in mind, I'm looking for the easiest way to do this.
Any help will be highly appreciated,
Andrés
View 1 Replies
View Related
Dec 28, 2005
Folks.
I just moved my domain to GoDaddy.com. When I run my website locally, everything works fine.
When I ftp it to my server space on GoDaddy.com, I get a "remote connection" error. Does anyone have an example of a connection string I should be using to connect while on the server?
Thanks!
View 2 Replies
View Related
Oct 21, 2006
Hi,
I am writing Stock inventory and POS application.
POS will be used at multiple branches to collect sales, whereby Stock Inventory will be used in HQ for product info maintenance, stock in and etc.
I need to send all of the branch sales records back to HQ and send updated product info such as cost to branches everyday (could be multiple times per day).
I am thinking to use SQL Server Express 2005 at branches and SQL Server 2005 standard at HQ.
Do you think it is workable? What is the mechanism I can use to "transfer" these data?
Please advice.
Thank you
View 1 Replies
View Related
Mar 26, 2007
I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server? I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated.
Thanks
View 3 Replies
View Related
Mar 19, 2007
Problem: (asp.net 2.0)I x-copy from my development server a database named C:site_testsite.mdf to C:site. When I attach the database with Server Management Studio Express, it list the name as: "C:site_testsite.mdf" eventhough on the live server the database is in the C:site directory and my connection string in my web.config is "C:sitesite.mdf". But everything works until a week later when I need to make a field change to a table on the live site: I'm forced to re-attach the database, but this time it list the database as:C:sitesite.mdf". When I re-attach I get a NT AUTHORITYSERVICE does not have permission. So I give NT AUTHORITYSERVICE permission on the directory and files and ownership with Server Management Stuidio Express, but I still get the error.What am I'm doing wrong? Thanks for the help--Dietrich
View 1 Replies
View Related
Jan 25, 2006
I am using a login control ( using SQL express) for my application. Everthing works fine in my local machine, but after I deploy the application to the production server, I am getting an error says: 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I think it's becasue the SQL Express database which has the user login information has been set up correctly in the production server: Here is my connection string for SQL Express in my local box <add name="SQLExpress" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> Any ideas what I should do to solve this issue
View 1 Replies
View Related
Jul 5, 2006
The project I'm working on has been developed using SQL 2005 Developer Edition and VS 2005, so up until now VS has been handling the task of deploying my C# managed code stored procedures to the database.
Now it's time to deploy a beta of the product, and we want to use SQL 2005 Express, and take advantage of it's new XCOPY deployment mode which in turn means we can also take full advantage of Click Once for our software updates. The idea here is that we can deploy new or updated stored procedures in a managed DLL using Click Once, making updates presumably more simple and robust.
So the steps we need to complete at runtime are:
1. Dynamically load and access the database MDF file using SQL Express (done).
2. Enable CLR Integration for the dynamically loaded DB (done)
3. Instantiate all of the stored procedures - help!
Looking at the docs, it seems we have to execute the following SQL for each and every SP:
CREATE PROCEDURE <Procedure Name>
@inputArg2 type, @inputArg2 type, @inputArg3 type OUTPUT
AS EXTERNAL NAME <Assembly Identifier>.<Type Name>.<Method Name>
But, we're talking about literally hundreds of stored procedures that need to be instantiated here, which obviously means a lot of double-definitions and a fairly high chance of bugs creeping in.
Surely there has to be a better way?
View 3 Replies
View Related
Jul 19, 2006
To deploy sql server express to an ISP that supports Sql Server, I backed up the .mdf and .ldf files.
I can connect to the ISP database with Sql Server Mangement Studio Express. That connection requires a password.
When I try to execute 'restore', I get an error for no permission.
Any ideas why I have no permission after a password has already been entered?
I sure appreciate any help.
View 7 Replies
View Related
Jan 24, 2008
Are there any way I can make changes to my database without stopping the web site? I'm using SQL Server 2005 Express for my web shop. And each time I have to add or change a table or Stored Procedure I have to stop the site. What I do is to stop the web site (in IIS), restart the IIS and then open the database in the SQL Server 2005 Express Management tool. If I don't "release" the file first I get an error when I try to open the database file in the Management tool.But there must be a better way to do things? I also would like to take bacup of the database without stopping the site, but how? There must be others that have had the same problems? Regards, Sigurd
View 3 Replies
View Related
Mar 29, 2008
hi,
I have developed my database on express edition of 2005 .Now I need to deploy this database which contains storedprocedure .will u give me some link for some help. I donot know from where to start.
And I also want to change the Authentication mode from windows to MIX mode for sa user ....or whatever the username is given by the hoster....
thanks urgent..
View 3 Replies
View Related
Mar 30, 2006
I'm on day 3 of troubleshooting.... still no luck!Very simple application. Extract data from the database and populate the GridView.Following error message:Server Error in '/WebSite3' Application.
An
attempt to attach an auto-named database for file
C:Webspaceigiriabcabc.comwwwWebSite3App_DataDatabase.mdf
failed. A database with the same name exists, or specified file cannot
be opened, or it is located on UNC share.-------------------------------------------------Look familar? so i Googled it and tried everything, from removing the User Instance = true in the web.config and even adding intial Catalog = Database and it didnt work.Instead i was greeted with a Newer Error msg:Server Error in '/WebSite3' Application.
Could not open new database 'Database'. CREATE DATABASE is aborted.Could
not attach file
'C:Webspaceigiriabcabc.comwwwWebSite3App_DataDatabase.mdf'
as database 'Database'.File activation failure. The physical file
name "D:-- Work Documents --WorkezabcWebSite3App_DataDatabase_log.LDF" may be incorrect.The log cannot be rebuilt when the primary file is read-only.Next i have no idea why it's pointing back to my location directory hence that could be the issue but i'll leave it to you experts for your valueable input.It's uploaded onto a web server running ASP 2.0 and MS SQL Server 2005 i thinkFeel free to ask if you need additional informationThanks for reading!
View 9 Replies
View Related
Jul 8, 2006
VWD Express 2005 -- My application is working fine on local computer.
I used FTP to transfer pages to ISP - done.
Now I need to store SQL App_Data on their separate server.
I have a tutorial from the ISP that shows a step by step procedure for SQL 2000 starting with Enterprise Manager.
Is Enterprise Manager available for SQL Server Express? If not, how do you deploy the SQL App_Data to the web?
thx
View 8 Replies
View Related
Nov 8, 2007
I have a vs2005 deployment project and have set prerequisites to include sql express. This is not what I need however since I need the advanced version with full text search.
How can I make sure that the advanced version of sql express is installed when my app is installed?
Is there any way to include the setup bits for adv. sql express in my install so the user doesn't have to connect to the internet? I know this is probably doable, just wonder if there are any specific docs or examples?
I have SQLEXPR_ADV.EXE and know the options for quiet install, but how to integrate into my install project?
View 3 Replies
View Related
Jun 17, 2006
i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.
Can this be done, and if so, how?
Observing God€™s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24). I believe God, so I thank The Lord Jesus for your grace in these matters.
View 4 Replies
View Related
Jan 9, 2006
Lets say I use the 'enabling roles' for my ASP 2.0 site. This creates a ASPNETDB.DBF SQL Express file.
Later I go to post this to a real web server - which runs the 'full' MS SQL2005 server. What happens to the ASPNETDB.MDF file (or for that matter, any other MDF file I create with SQL Express) when it leaves the Express world and enters the Real world.
View 4 Replies
View Related
May 20, 2006
I have installed SQL Server 2005 Express Advanced Edition. I wan to use it as a database backend for a Web Site I am building which will use the Snitz Forums ASP web. How do I se this up to work with the Snitz product? Yes I am new to databases and have never set up one for use in a web application or site before. I am grateful for any assistance or tutorials which can be given to help me accomplish this task.
View 9 Replies
View Related
Mar 5, 2006
I have installed sql server express 2005 and also visual studio express developer when i run the personal web site sample I get the folowing error
Shared Memory Provider, error: 40 - Could not open a connection to SQL Server
How do I correct this please does any one know ?
View 4 Replies
View Related
Jun 2, 2006
Hey everyone,First off, sorry if this has been asked and answered before--I've tried searching the forums but may have just not used the right criteria. Anyways, I'm new to .net and all that stuff, and I was wondering if there were any differences (code-wise) between developing on 2005 Express and running on SQL 2000. I know there would be variations in the connection string, but I wasn't sure about anything else--specifically if they both use the sql provider thingy (I forget the name of it, since I don't have my book in front of me). I don't expect there to be many differences, but I wanted to check before I got too deep into coding.Thanks in advance.
View 1 Replies
View Related
Jul 23, 2007
I am trying to add a SQL Server 2005 Express Edition Database to my Web Site. But I am unablr to do so.
I am getting the following error: {"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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
I am unable to understand what exactly is the problem.
Pls Help me out.
Thanx In Advance.
View 2 Replies
View Related
Mar 31, 2006
I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express. I ran the aspnet_regsql and it created the aspnetdb database. But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work. I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail. My SQL Server is installed on the Default Instance. Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?
View 1 Replies
View Related
Jun 18, 2007
Am getting errors trying to deploy a dtsx created by ms (the reporting services execution log one) to which I have made zero changes, but it is not working (2 errors shown below)
error from deployment wizard:
===================================
Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxx". (Package Installation Wizard)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
error from sql management studio
===================================
Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)
View 7 Replies
View Related
Feb 14, 2007
Dear all,I've been using ASP.NET with SQL 2005 express for several months and everything has been fine. Now a customer asks me to install my application on an already existant instance of SQL Server standard edition.I was not able to use nor my application, neither a HelloWorld example.I created a simple Default.aspx that uses a simple database with a single table "Person" via a standard gridview. When I try to open the page I receive an error wich informs me that NT Network service is not able to access database.I've been searching on google for hours and I've tryed unsuccessfully several different way.Can anyone suggest me a scientific procedure to migrate an ASP .net web site from sql 2005 express to sql 2005 standard ?Thank you very Much Fabrizio
View 1 Replies
View Related
Jul 26, 2001
I recently came across this built-in role in MSDB. It is not documented anywhere except sp_create role stuff. Does anyone know what this role is used for? Is this what gives users that are not dbo or sa access to see jobs?
View 1 Replies
View Related
Aug 15, 2007
Hi,
Is there some kind of built in function in SQl to look for the presence of certain characters in a table collumn.I have to replace the text in those collumns with different text or just use substr, instr functions.
Thanks in advance
View 4 Replies
View Related
Jun 13, 2006
I have built a simple package using the Microsoft OLE DB provider for DB2 with SSIS Developer. If I schedule this on a Standard SQL2005 machine the package will not run. The error is blank, just says it had an error. Can I not run this package because the provider is not installed on this machine? If so is there a work around for this?
View 2 Replies
View Related
Aug 21, 2000
Does anyone know if SQL has a built in function for returning increments of rows. For instance; I have a table with 100,000 rows, but would like to return 512 rows at a time. I've looked at the documentation and haven't came across anything that will do this. Any help is appreciated.
View 4 Replies
View Related
Jan 28, 2004
Hi.
I am a beginner of SQL server.
I have a table namely Customer with a column "CustomerName" with data type varchar and length 50.
Column Name-Customer Name
Data Type- varchar
Length- 50.
May I know how to ENSURE that every customer's name only contain ALPHABET and strictly avoid the numeric character and
other characters such as "&, !,#....".
Please help. Thank you.
View 6 Replies
View Related
