Can I Use SQL Server 2005 Developer With Visual Web Developer?
Nov 24, 2007
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I was about to order SQL Server Developer Edition 2005 on Amazon, to use with Visual Web Developer 2005 Express, when I read a user comment that the two are incompatible with each other. Does anyone know for sure if that is true?
What I'm wanting to do is develop an ASP.NET web application on a web host using a SQL Server database. I use VS2003 and SQL Server Enterprise 2000 at work, but I'd like to learn the 2005 editions for this side project. I don't own any of the developer tools/IDEs personally, so I'm trying to find the most affordable way to do this for my home business.
Yes I am a newby (or is that newbie) and this is my first post.My Visual Web Developer site work really well on my PC, I read the books took it slowly, created logins and sql tables and then found a good hosting company with Server 2005 ... I though I was one step away from the road to success ... then I hit the big brick wall. Spent hours on Google trying to find some answers without joy ... all I found were lots of users with the same or similar problems ... and some answers that caused more problems !1) Please can someone give my a 'step by step' idiots guide on how to convert my ASPNETDB.MDF content to run on Server 2005. I have Server Management Studio so I am happy about loading the translated files but I don't understand how to break them down into tables and logs.2) Once the files are across can I run a connection string from VWD directly to the tables on the server instead of SQL local ? I assume that is set in web.config !!.... normally I am happy to learn by trial and error. But I can't get around or over this brick wall.Welcome assistance, advice or a ladder ... with simple instructions ?
Hello Everyone, I have just installed then above softwares and I am trying to work on a very simple application.On my Default.aspx I created a Gridview and connected it to the dabase.Everything works fine?When I try to work on the Security under Website->ASP.NET_Configuration I get the error: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I see that a lot of people get this problem. Can someone sugest a way out?Thnaks in advancePati2005
I am developing an asp.net app using visual web developer. I am using a sql server 2005 db for the back end. I have learned that I have to restart my machine if I want to work with the db in SQL Server 2005 Express after working with it in Visual Web Developer.
I am wondering why this is. I am assuming that the db is locked when it is used with VWD. Is this correct? Am I refering to it's status of "locked" correctly? Should I call this something else?
Hi all i have a page with this code <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="36"> <PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" /> <Columns> <asp:BoundField DataField="ACCOUNT_REF" HeaderText="ACCOUNT_REF" SortExpression="ACCOUNT_REF" /> <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" /> <asp:BoundField DataField="ADDRESS_1" HeaderText="ADDRESS_1" SortExpression="ADDRESS_1" /> <asp:BoundField DataField="ADDRESS_2" HeaderText="ADDRESS_2" SortExpression="ADDRESS_2" /> <asp:BoundField DataField="ADDRESS_3" HeaderText="ADDRESS_3" SortExpression="ADDRESS_3" /> <asp:BoundField DataField="ADDRESS_4" HeaderText="ADDRESS_4" SortExpression="ADDRESS_4" /> <asp:BoundField DataField="ADDRESS_5" HeaderText="ADDRESS_5" SortExpression="ADDRESS_5" /> </Columns> <PagerStyle HorizontalAlign="Center" /> </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SageConnectionString %>" ProviderName="<%$ ConnectionStrings:SageConnectionString.ProviderName %>" SelectCommand="SELECT ACCOUNT_REF, NAME, ADDRESS_1, ADDRESS_2, ADDRESS_3, ADDRESS_4, ADDRESS_5 FROM SALES_LEDGER"> </asp:SqlDataSource> On my local machien this works great and I'm very happy with it I then uploaded the site onto the server on running the page i get this
ERROR [08001] Cannot find all files in data pathERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
can anyone suggest a eresolution? i'm confused since it works on my local machine fine but not on the server
(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like the following:
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) (Microsoft SQL Server, Error: -1) I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools. My configuration::
Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it.
IIS is installed and the service says its running
VSQL and VWD express versions installed (no errors on installation)
SQL server service indicates it is running
.Net 2.0 framework installed (no errors on installation)
Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental.
Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
I'm new to SQL Server and am now learning how to operate SQL Server Express 2005.
I'm getting the following error when attempting to install Visual Web Developer 2005 SP1.
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch"
My machine runs on XP Pro SP2, .NET Framework 3.5.
Currently, what i have got on the computer are as follows Microsoft SQL Server 2005: SQL Server Management Studio Express, SQL Server Configuration Manager.
Hi, I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error"error occured in establishing the connection". I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf? thanks and urgent help needed
i am trying to build a database that contains a coloumn of phone number but i reallly dont know where and how i will be able to give a specific format for phone numbers.. or anything else any common type of information that may have a format..
Will i use Visual Web Developer or SQL Server Management or whatever else to arrange my phone number coloumn?
Hello Im pretty new to development so..... be nice guys. I have VS2005 pro and SQL Server 2005 developer edition installed. When I open VS, in the server explorer i can connet to databases located on the SQL directory (SQL Server runs perfectly) But when i try to add an sql server to my project( add new item --> SQL database) it gives me an error saying "Connection to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component......" HELP! donno what VS wants!
Hey, Im trying to make a website that I can enter information on the website and have it transfered to the database the problem is the website and database are on two different computers , how do I copy the data base onto the other computer and have it will be ready to take information from the website and store it in the database?
hello eveyone..i have just downloaded and installed the visaul web developer 2005 express edition and sqlserver 2005 express edition.On top of that i even downloaded and installed the northwind database.But my problem is when i am connecting to the northwind database by clicking toos menu>connect to the database>choose datasource>new connection>..i have provided it with the required information..but as soon as i press "Test Connection" button the following error box displays.. "an error has occured while establishing a connection to the server.when connecting to the sql server2005,this failure may be caused by the fact that under default settings sql server doestnot allow remote connections.(provider:Named piped providers,error:40-couldnot open a connection to sqlserver.)" i have no idea whats is all about..can anyone get me pass this error..
I have SQL Serrver 2005 Express Edition with Advanced Services running on a machine with Vista Home Premium o/s.
I am trying to build the Personal Web Site Starter Kit using Visual Web Developer 2005 Express Edition but keep running into problems when trying to establish user instance. The error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The conmnection will be closed" keeps coming up.
The following services are running:
SQL Server (SQLEXPRESS)
SQL Server Browser
SQL Server Full Text Search
SQL Server VSS Writer
I note from the documentation that a new instance should be created in the directory :
C:Documents and Settings<User>Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS.
Unfortunately that directory does not exist on my Vista machine. Is this a fault?
I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx
It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message:
"There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor"
Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing.
I installed both SQL 2005 developer and SQL Server 2005 Express Edition with Advanced Services SP2 and Microsoft SQL Server 2005 Express Edition Toolkit.
In every version "SQL Server Business Intelligence Development Studio" was missing. I uninstalled and reinstalled both version but always "SQL Server Business Intelligence Development Studio" was not available and the computer could not find devenv.exe file.
I installed visual studio 2008 as well. For some reason the start menu link for "SQL Server Business Intelligence Development Studio" is ""C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe"" and devenv.exe is not there or anywhere
hi., i need help.,i Created a database using the SQL Server 2005 Express SQL Server Management Studio Express (SQL Server MSE)but i don't know how can i get the database that i made to put it in the Folder "App_Data" in my Visual Web Developer (VWD). is there any process or something to connect my database that i make using the SQL Server MSE to the VWD?Please help me, THanks
i have visual web developer make the asp.net.mdf that it auto made, for the users and roles, i added 2 more coloms to the database in the membership table called address and phone
when i make a sqldatasource and give it a select and insert command, i also give it a couple dummy values to test it this is my code,
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs) SqlDataSource1.InsertCommand = "INSERT INTO aspnet_Membership(Address, Phone) VALUES ('9', '2')" End Sub <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:saveaddnphone %>" SelectCommand="SELECT Address, Phone FROM aspnet_Membership"></asp:SqlDataSource>
Instance failure. 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.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I have installed Visual Web Developer Express and its companion SQL Server 2005 Express in my Windows XP Professional box.
Now I want to create a database using Visual Web Developer. I opened the Database Explorer and right clicked on Data Connections icon but what I am seeing is an inactive "Create new database" command.
How can I make it active ? How to create a database using my Visual Web Developer?
I can access an SQL Server 2005 database from VWD, but for ease of uploading to a server and to maintain the database within just VWD environment would like to import it directly into VWD and its App_Data folder from the local machine SQL Server. I guess this is more than copy and paste ('especially since this is not allowed becase the database is being used by another program'). I've seen posts about the reverse process but not this way. Any simple pointers please?
I'm developing using Visual Web Developer and want to have a web page that shows the contents of a table. I get the error message when testing the connection through database explorer "Login failed for user ''. The user is not associated with a trusted SQL Server connection". The database is located on a server running IIS and has SQL Server Express installed.
I'm developing using Visual Web Developer and want to have a web page that shows the contents of a table. I get the error message when testing the connection through database explorer "Login failed for user ''. The user is not associated with a trusted SQL Server connection". The database is located on a server running IIS and has SQL Server Express installed.
I use Visual Web Developer 2005 Express Edition. Anybody help me how can i use reports and subreports with parameters in it. I am new to ASP.NET. Please give me a sample. Thanks in advance.
I successfully installed .NET framework v 3.5 and VWD 2008 on a new Vista laptop. When I want to add a Sql Server database to a website, errors tell me to install SS 2005 Express. MSDN SS 2005 Express download tells me I MUST first install .NET framework v 2.0 before SS 2005. When I try to install framework v 2.0, I'm sent to v. 3.5 and no way to download SS 2005.
How does one install a express sql server to run with Visual Web Developer 2008?
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.
I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.
Have I been clear enough on what I am looking for? I don't quite feel like I have.
Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?
I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.
Also, do you see value in the studying process for certifications in this area?
I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Hi, Can I use Sql Express Edition with Visual Web Developer at the same time? I tried but I always get a permission error. Also, when I try to attach a database (that I created in Visual Web Developer) to the SQL Express i cant find the .mdf file, I don't know why? Is there is a way where I can specify a folder where I can keep the mdf and allow both applications to access it?
lo all, when i try and connect web developer to a sql file i get "An error 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:Named Pipes Provider,error : 40-Could not open a connection to SQL server)" thx for any help Charlie
