VWD && SQL 2008 Express
Jan 1, 2008
I installed VWD 2008 on my Vista Business. I had a lot of trouble installing SQL Express 2005 & SQL EXpress 2008 CTP and SQL Express 2008. Finally managed to install SQL Express 2008 on my Vista Business. If anybody has problem installing SQL Express on Vista let me know. I found resources on MSDNER and this forum to resolve this.
But now I have a new problem that is. I can not add the SQL connection from DataExplorer of VWD 2008. It say it can connect only up to SQL 2005. Now I try to install SQL 2005 it goes up to the stage where it says looking for IIS server and disappears.
Does anybody know how to install SQL Express 2005 on Vista Business (while SQL Express 2008 is installed, I don't want to loose it) or get VWD to talk to SQL Express 2008?
Your help is much appreciated.
View 1 Replies
ADVERTISEMENT
Feb 25, 2008
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
View 1 Replies
View Related
May 7, 2008
Downloading and installing VS 2008 Express also created a Miscrosoft SQL Server folder. How do I install the SQL Server 2005 Express?The following is what I found from the HELP menu bar of the VS 2008 Express. Where can I find the sqlexpr.exe?
TIA,Jeffrey
To install SQL Server Express To begin installation, double-click sqlexpr.exe. Note: SQL Server Express is available as a self-extracting executable file (sqlexpr.exe) from both the Visual Studio 2005 CD and the SQL Server Express Web site. SQLEXPR.EXE installs on x86-based computers and to the 32-bit subsystem (WOW64). For more information, see Hardware and Software Requirements (SQL Server Express)
View 1 Replies
View Related
May 7, 2008
I installed VS 2008 Express with an option to download SQL Server 2005 Express. I noticed there is a '90' folder under my Microsoft SQL Server folder. I assumed this the folder for SQL Server 2005 Express.
How do I set up my SQL Server2005 Express, so that I can use some sample databases for my VS 2008 Express? Any difference for SQL Server 2005 Express between VS 2008 Expressdownload and SQL Server 2005 Express download?
TIA,Jeffrey
View 3 Replies
View Related
Mar 20, 2008
Hello
I recently installed the SQL Express 2005 program after successfully installing C# Express 2008.
When I add a new item (Database1.mdf), I get this error:
"Local database file
An error has occured 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 have restarted my computer and this does not solve the problem. As I am not familiar with SQL (I am following the Tier 2 tutorials at MSDN), I didn't modify any options when installing program.
How do I fix this error?
Thank you
View 4 Replies
View Related
May 7, 2008
I installed VS 2008 Express wi th an option to download SQL Server 2005 Express. I noticed there is a '90' folder under Microsoft SQL Server. How can I set up SQL Server 2005 Express, so that I can use some sample databases for VS 2008 Express?
TIA,
Jeffrey
View 5 Replies
View Related
Mar 28, 2008
Hi guys,
Looking for some help please...
I have developed a Site using VWD express 2008 and within the site I added a Log-in control and this generated a Database for me called ASPNETDB.MDF, I used this DB with the site Admin feature (Again the auto generated pages!) to add some users so I could test the function of the control. All worked fine :-)
Then because I wanted to make some large additions to the DB I used SMS Express to attach to the DB and make the required changes (Add tables etc!). Once finished I detached from the DB in SMS and closed it down then re-opened VWDx and tried to view the DB but got the following error:
Unable to open the physical file
"C:*********App_DataASPNETDB.MDF". Operating
system error 5: "5(error not found)".
An attempt to attach an auto-named database for file
C:************App_DataASPNETDB.MDF failed. A database
with the same name exists, or specified file cannot be opened, or it is
located on UNC share.
(Stars added by me to hide my folder structure etc!)
I am using a Vista machine with ISS installed to any help would be appreciated, as I have tried everything I can think of and no luck.
It's been 2 days now and I am now bald so please give me some good news.
Thanks.
View 2 Replies
View Related
Nov 30, 2007
Hi
I have installed VB Express 2008 and also SQL Express 2005, I am working my way through the online tutorials but when it deals with SQL databases I am getting confused as when I add an item i can see the options for local database or server-based database, on the tutorial is shows as sql database which is an option I do not have. I wanted to check is this was correct as SQL Express 2005 is installed on the machine. Am I missing a component, I installed SQL Express 2005 as part of the download through VB Express 2008,
Any help would be great.
Thanks
View 3 Replies
View Related
Apr 7, 2008
is there a version of SQL express 2008 ??
View 1 Replies
View Related
Jun 12, 2007
I see the Developer edition of SQL Server 2008 is available. When will the Express version be available?
View 3 Replies
View Related
Jun 18, 2008
I was wondering if this is normal. I am creating a website in VS 2008. I created a SQL db and am using SQL server express.
I can go into SQL server managment studio express and open the DB when I start my PC. I can still access the DB when I start VS 2008 and my project but when I run the project I can not access the DB any longer even when the project is not longer running and I'm in design mode. Even if I close VS 2008 I still cannot access DB through SQL server managment. The only way I can access the DB again is if I restart my PC.
Is this normal?
I am running Vista Ultimate.
Thanks,
Ty
View 3 Replies
View Related
Apr 15, 2008
Hello,
Does anyone knows if SQL Server Express 2008 is already available for download? Where can I get it?
Thanks,
Miguel
View 1 Replies
View Related
Dec 7, 2007
Will the 2008 edition of SQL Server Express contain the new row level compression features? Is it available in the current CTP for us to try out?
Thanks
View 1 Replies
View Related
Mar 31, 2008
I finally have SQL Server 2008 Express CTP up and running.
Should it be possible for a VB 2005 Application to connect to SQL Server 2008 Express?
Or does the VB 2005 Application have to be upgraded to VB 2008 (including service pack)?
Thanx,
Richard
View 3 Replies
View Related
Mar 10, 2008
I have installed sql server 2008 express edition native client (X86) on my win XP machine (SP2). But i cannot see the sql server 2008 installed. i have already installed sql server 2005 express edition. After that i installed 2008 express edition. Currently i use sql server 2000 (real version) in my company.
can you pls tell me, where and how can i use the sql 2008 express version after installing it.
rgds
hari.
View 4 Replies
View Related
Dec 15, 2007
I have installed the November CTP of SQL Server Express 2008 but the service will not start. The error log displays the following error which implies that it is trying to open a file on by CD/DVD drive. I have checked the service properties and all the parameters point to c:
Any idea why it is looking at e:? Where do I change this?
Starting up database 'mssqlsystemresource'.
2007-12-16 09:46:43.82 spid7s Error: 17204, Severity: 16, State: 1.
2007-12-16 09:46:43.82 spid7s FCB:pen failed: Could not open file e:sql10_main_tsqlmkmastrobjfrei386mssqlsystemresource.mdf for file number 1. OS error: 21(error not found).
2007-12-16 09:46:43.85 spid7s Error: 5120, Severity: 16, State: 101.
View 3 Replies
View Related
Feb 23, 2008
I have been following the Visual Basic Guided Tour for VB 2008 Express and I'm having a problem with the following part.
ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/dv_vbcnexpress/html/48fcb538-d8c7-4299-a2bf-a5b6f80d879d.htm
Creating LINQ to SQL Classes: Using the O/R Designer
I am getting the error "Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.", when I get to the Test Connection button.
I have found the following help page,
ms-help://MS.VSCC.v90/MS.msdnexpress.v90.en/SqlExpressBol/html/85385aae-10fb-4f8b-9eeb-cce2ee7da019.htm
but I have no idea how to use this information as it assumes the user knows what they are doing!
The solution appears to involve running a scipt of some sort, but where would that be run?
I have looked at the SQL server Express information, but can't find how to run sp_configure.
Your help would be much appreciated.
View 4 Replies
View Related
Feb 25, 2008
"When attempting to run this installer (SQLCMD T-SQL execution command line utility), I get the DOS screen but not the 1> command prompt. If I leave the screen alone, the DOD command window closes after about 5 seconds."C:Program FilesMicrosoft SQL Server90ToolsinnSQLCMD" -S "machine-nameSqlExpress""
nuno vieira
Hi All
Can someone help me please?
ive just got a new machine and not had this problem before, at one point the error which appeared briefly before the command prompt window disappeared said it was the namepipe, so i enabled this, that didnt work so i uninstalled, and reinstalled SQL Server 2005.
The next error message i received when the command prompt was closing was (in brief)
HRESULT 0xFFFFFFF Level 16, State 1
an error occurred whilst establishing a connection to the server
Sqlcmd: Error: Microsoft Native Client : Login timeout expired.
I have just updated to sql server 2008 and the same thing happened. I cant paste into the SQLCMD window and I havent got a 1> command prompt.
I tried to drop down into dos prompt and it wouldn't accept it said "the filename, directory name or volume syntax is incorrect".
I turned on iis, ive tried everything I can think of, i have come to the conclusion it must be something to do with the version of Windows Vista Home Premium I am running, I haven't had any problems on any other machines XP or Vista.
Any help would be gratefully accepted.
Cheers
sgblank
View 4 Replies
View Related
May 3, 2008
I am using the Adventureworks database to to some development training in VB Express 2008.
I have reinstalled the the database from scratch three times. I can successfully attach the database in the SQL Server management studio, but as soon as I make a connection to the database in VB Express and then try to go back into the studio to verify my data changes, I get an error message that the log file does not match the data file. After I get that error in the SSMSE, I can no longer establish a connection in VB Express (login fail error message).
The only solution I've found is to reinstall the .mdf and .ldf files. Obviously, that's not getting me too far in my learning. Hopefully someone can help me out?
View 3 Replies
View Related
Apr 22, 2008
Hello,
On a windows 2003 server R2 x64, i had the Framework.net 3.5, Sql Server 2005 express (instance s423553 on NT SERVICENetwork) and Visual Web Developper 2008.
I installed Sql Server Express 2008 Express (install .SQLexpress with the local account sqlserv10). The first time (with the account NTSERVICENetwork), it failed. I uninstalled it and Sql Server Management Studio 2005. The second time, the install end properly. But, can't find SSMS. On a MsSql2008 microsoft page, i've found a link for SSMS 2005. So i installed it.
But, on this server, Sql Server Management Studio Express 2005 does not work with Sql Server 2008. I tried to use the 2008 Instance with Visual Web Developper 2008 but it didn't work (only compatible with sql server 2000, 2005....).
Could you help me please ?
Thank you.
View 1 Replies
View Related
Apr 25, 2008
Please make this sticky or put it into the faq:
Note: Using Windows Vista Ultimate
SQL Server 2008 Express Edition download page says in big letters, "You Must Install .Net Framework 2.0." The link provided to .Net framework -- framework/ take me to a page that only lists .Net Framework 3.0, with a notice that 3.5 redistributable has been released. What is the correct version of .Net Framework to install SQL Server 2008 Express Edition - 2.0, 3.0, 3.0 + 3.5, or just 3.5?
View 5 Replies
View Related
May 11, 2008
Hi,
I have used MIcrosoft Sql Server 2000 for a while, namely analysis services. What I want to know is if Sql Server Express Edition 2008 has also tools to handle with datawarehouses, olap and data mining, that is, which are the limitations of SQLServer 2008 Express Edition, they are related with that tools?
if it provides that tools, do you know good documentation related with these issues?? And books??
Thanx for your help
MP
View 6 Replies
View Related
Apr 24, 2008
Hi Folks,
I have an access 2007 data base for document control and it saves the received documents in a table in a attachment field type, I tried to upsize it to SQL Server 2005 but after upsizing realized that this field type is not supported by 2005 so I downloaded the SQL Express 2008 and installed it as it has this enhancement but Access 2007 doesn’t recognize the server for upsizing.
I appreciate you help
Thanks :beer:
View 13 Replies
View Related
Jun 17, 2008
I downloaded SQL Server 2008 Release Candidate (Express) Beta on 6/16/08. Installation started but failed. A message stated Microsoft NET Framework 2.0 SP2 needs to be installed first.
I downloaded SP2 and installed it. However, when I try again to install the SQL 2008 Release Candidate Beta I get the same message that SP2 must first be installed.
Can someone tell me how to make the SQL Beta version installer recognize the previously installed SP2 Service Pack?
Thanks, Norman
View 1 Replies
View Related
Apr 25, 2008
Well, what I want is to be able to do some tooling on a database (.sdf) on my WM5 device using C# Express 2008.
The problem is that when I select the "Tools/Connect to database" option, I choose my data source to be "Sql Server Compact 3.5" in the next screen, and when I press Continue, I am taken to the next screen, and here I cannot select the "ActiveSync connected device" in the "Data Source" section...it is disabled. The only option is selecting "My computer"...but I do not need that.
Is there something I need to install in order to activate that option?
Thanks,
Adrian
View 4 Replies
View Related
May 5, 2008
Is there a Business Intelligence Development Studio, Management Studio Express for SQL Express 2008 CTP?
If so where can I find this software.
Willie
View 5 Replies
View Related
Sep 7, 2009
I am getting following error when I try to create the 1st diagram for my existing database in SQL server management studio . I am using sql server 2008 express. Operating system is Vista basic home. I was able to get past the "no valid owner error" problem by using the ALTER PROCEDURE; now I have the following: Invalid column name 'uvalue'.Invalid column name 'uvalue'.Could not find stored procedure 'dbo.sp_upgraddiagrams'.Object is invalid. Extended properties are not permitted on 'dbo.sysdiagrams', or the object does not exist.Object is invalid. Extended properties are not permitted on 'dbo.sp_upgraddiagrams', or the object does not exist. (.Net SqlClient Data Provider)/
View 3 Replies
View Related
Jan 26, 2008
Hello,
When I was installing vs.net 2008, I chose to install sql server express. But after I installed it, I found I could only see the configuration tools of sql server, but I couldn't find the sql server express service. When I ran the surface area configuration for services and connections, I msgbox came out and told me "No sql server 2005 components were found on the specified computer.....". Why?
Thanks.
View 1 Replies
View Related
Apr 7, 2008
I'm trying to integrate office accounting 2008 express w/outlook 2003 w/BCM. I'm able to add items created in accounting to a BCM opportunity, but cannot convert an opportunity into... (I don't know what, the button is ghosted out) Oultook or BCM doesn't see customers added in accounting. I have no problem establishing a connection from BCM, with the above results. In accounting, the wizard cannot see theany BCM databases, nor will it accept data entry. Any help?
View 4 Replies
View Related
Feb 12, 2008
I already have SQL Server Express 2005 installed from having Visual Studio 2005 installed. How can I tell if it is the SP2 edition? It probably isn't, so my next question is what is going to happen when I install Visual Studio 2008, which I will be doing in a day or two...will the install overwrite SQL Server Express 2005 with the latest edition to SP2, assuming that the latest edition will be on the Visual Studio 2008 installation discs? I have not yet used SQL Server Express, so my knowledge level with it is very weak. What I'm hoping to find out with this question is what I'll have (with respect to SQL Server Express) and the install of Visual Studio 2008. I can't even figure out how to tell what version of SQL Server Express that I now have.
View 9 Replies
View Related
Sep 10, 2007
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?
View 4 Replies
View Related
Apr 21, 2008
Hi all,
I have installed the The Microsoft Report Viewer 2008 Redistributable Package and I add the report viewer component to my toolbox list.
while viewing the report viewer in my solution ...i was getting the error as given below..
Note:
InnerException = {"The report definition is not valid.
Details: The report definition has an invalid target namespace
'http://schemas.microsoft.com
/sqlserver/reporting/2007/01/reportdefinition' which cannot be upgraded."}
Can I know the solution for the error..
Thanks,
Ashok.
View 1 Replies
View Related
Mar 25, 2008
Hi
I need to Install the SQL server 2008 express with Instance name and Sa password parameter in silent mode . I tried couple of command line arguments for this. but It didn't work, I got the setup failure error message
"The setting 'QB' specified is not recognized.Error code 0x84B40003."
Can any one help me with this?
These are the commands I tried.
1) sqlexpr.exe /qb instancename="MACHINENAMESQLEXPRESS2008" SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=1 SQLAUTOSTART=1 SAPWD="PWD" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0"
2)SQLexpr.exe /qb /ACTION=Install /FEATURES=SQL /instancename="MACHINENAMESQLEXPRESS2008" SAPWD="PWD" SECURITYMODE=SQL
Thanks in advance.
Regards,
Nav.
View 1 Replies
View Related
