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.
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..
We are currently migrating our sequel 6.5 databases to sequel 2005
We have a handful of vb6 apps that connect to the current 6.5 database.
Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ?
Thanks in advance.
I'm planning an SQL 2005 deployment and would like to know if an SQL server should be kept as dedicated as possible. Should apps that access SQL be kept on other servers? What are the do's and don't's along these lines? The plan here is to install everything that accesses SQL on the same server with the database, but this seems like a bad move to me. Am I right?
Thanks!
Gregg
In VS 2005, using the ReportViewer control on a form in a Windows app, I've created an Object Data Source for the report by following the walkthrough in the documentation, it works.
View 4 Replies View RelatedHello 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
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 RelatedI 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 RelatedThe 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?
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.
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!
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
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?
Writing to tables created by regular users on MSSQL2005
I have users creating tables through an application, I gave them ddl_admin, datareader, datawriter. They can create tables but cannot insert/update data (to their own tables), I cannot insert data either using Access or any other application to those tables created by them (under dbo schema) Is there something I am missing with permissions? Thank you very much
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 RelatedHi,
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!!
How can deploy Reporting Service 2005 runtime with VisualStudio 2005?
The reason here goes...
I have completed my project in VS2005. Now I am trying to make package. But here, i do not know how to deploy Reporting Service (My Report files) to Customer's Server with Setup or any other runtime solution.
thanks
any replay will be appreciated.
I have a Windows 2003 Server running IIS 6.0 and SQL Server 2005. I have just (Today) deployed the first ASP.NET application (developed in Visual Studio 2003 and, as such, dependent on .NET Framework 1.1) on this server and am getting HTTP Error 403 (You are not authorized to view this page). This ASP.NET application runs fine on another server that is configured with the OS=Windows Server 2003, IIS=6.0 but without SQL Server 2005 and without the .NET Framework version 2.0. I found in the IIS Application configuration (on the troublesome site) that my app (in the Default Web Site folder) was pointing to the version 2.0 aspnet_isapi.dll. All efforts to use aspnet_regiis to "re-align" my app with version 1.1 have been fruitless to eliminate the HTTP Error 403. I granted the NETWORK SERVICE account privledges to the wwwroot folder. At this point, I don't know if I have a Framework error or a privileges problem.
Please help.
Thanks,
Rob
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)
I'm still getting used to SSIS and I'm wondering how to deploy all 20 of my ssis packages to my sql server 2005 machine in the msdb?
I could open each one and then save a copy as, but by default it doesn't put the name of the package in so I must copy and paste.
thanks.
As we know Sql Server 2005 provides its ability to deploy clr assembly on it. However my problem is that my assembly has a configuration file. I used ConfigurationManager.GetSection to create some of the object. When I am deploying the project the trouble is that the app.config is missing. I used a class lib project type to create the assembly. Besides changing a storing method, can I still use this config file to reach my goal? Sqlserver.exe.config is not a good idea and it is not workable. The sqlserverexe host cannot find the assembly files.
Thanks very much!
Hi,
when deploying assembly from VS into SQL Server 2005, deployment fails with these error messages:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I'm deploying assembly with UNSAFE permission setting.
What's wrong, please?
Thanx, Fipil
When I try to put a new report in existing folder there's no problem,but now i have fresh installed Reporting Services and no Visual Studio2005. How do i open a new folder?
View 1 Replies View RelatedSSIS packages can also be run on systems where SQL Server is not installed.
How do we package the DTUTil.exe and DTEXEC.EXE. with the manifest file
How do we execute the packages using the file system utility.
Any suggestions/help is appreciated.
Regards,
Rashmi
This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.
I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"
When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.
Thoughts?
Thanks
Hi,
just wanted to know,
Is it possible to deploy a report develped by 2008 on to ssrs 2005 server, if so does it work fine.....?
I'm brand new to web and ASP programming, but experienced with VB/VB.NET and SQL Server 2000 programming. I followed a tutorial and built a little website that lets you create a user login, login and change your password. I built this in Visual Studio 2005 using VB code and my understanding is that the site uses a SQLExpress database. There's an aspnetdb.mdf and .ldf file in the App_Data folder.
I want to deploy the website to a web server that is hosting SQL Server 2005, not express. Can someone be explicit about steps to take in order to do that? I've been trying a number of things in the web.config file, but I cannot seem to make a connectionstring that works. I also don't know what to do with the .mdf and .ldf files from the development server--I'm thinking they should not be deployed. Thanks for anything.
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
Hi All,
I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.
I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.
Any ideas?
Thanks! GB
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies View RelatedThis problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions?
Private Sub UpdateMemberTable()
Me.Validate()
Me.TblMembersBindingSource.EndEdit()
Me.TblMembersTableAdapter.Update(Me.ChurchFamilyDataSet.tblMembers)
Me.TblMemberDependentsBindingSource.EndEdit()
Me.TblMemberDependentsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberDependents)
Me.TblMemberContributionsBindingSource.EndEdit()
Me.TblMemberContributionsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberContributions)
End Sub
Hi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman