asp.net 3.5 in vb

ramila · January 12th, 2012, 03:20 PM

actually i didn't installed the sql server on my laptop by myself.but my friend installed that and he told that was the sql server 2005 express only..(using windows 7) still i m getting error.

when i drag PlanetWrox.mdf and PlanetWrox_Log.ldf form resources of ch-11 to new website NOT THAT SITE which used throughout in book . then when i double click the PlanetWrox.mdf i get following error:

Required Component Missing
Connection to SQL Server files(*.mdf) require SQL Server Express 2005 to function properly.Please verify the installation of the component or download from the URL:
http://go.microsoft.com/fwlink/?LinkID=49251

even when i add new database to SITE website by add new item ->sql database but when i click add button i get same error as above.

when i click start->All Programs i get following folders
1)Microsoft SQL Server 2005
-SQL Server Business Intelligence Development Studio
-SQL Server Management Studio

2)Analysis Services
-Deployment Wizard

3)Configuratin Tools0
-Notification Services Command Prompt
-Reporting Services Configuration
-SQL Server Configuration Manager
-SQL Server Error and Usage Reporting
-SQL Server Surface Area Configuration

4)Documentation and Tutorials
-SQL Server Books Online
4a)Tutorials
-SQL Server Mobile Edition Tutorials
-SQL Server Tutorials

5)Performance Tools
-Database Engine Tuning Advisor
-SQL Server Profiler

and i have following component installed in control panel:-
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Backward compatibility
Microsoft SQL Server 2005 Books Online(English)
Microsoft SQL Server Compact 3.5 Design Tools ENU
Microsoft SQL Server Compact 3.5 ENU
Microsoft SQL Server Compct 3.5 for Devices ENU
Microsoft SQL Server Database Publishing Wizard 1.2
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files(English)
Microsoft SQL Server VSS Writer

i also checked out the enabling remote conection
when i select SQL Server 2005 Network Configuration(32bit) i got following protocols:
Protocols for MSSQLSERVER
Protocol Name Status
Shared Memory Enabled
Named Pips Disabled
TCP/IP Disabled
VIA Disabled
when i change Named Pips ans TCP/IP TO Enabled and restart my sql server management studio
i get the following error :
Unable to stop service MSSQLSERVER on server USER-VAIO(USER-VAIO is my server name)

what should i do ..i stop on ch-11 - cant go to further chapters TRY IT OUT..

One more thing whenever i start sql server management studio and start connection to server i use server authentication(server name-USER-VAIO, login-sa password-sa)
can i change it to window authentication?
my server name is-USER-VAIO(SQL Server 9.0.1399 - sa) this is only my instance right?

Imar · January 12th, 2012, 05:06 PM

Hi there,

When you log in to SQL Server using Management Studio, what's the name of your SQL Server you log in to? Does it work when you log in to . (just a dot)?

Imar

ramila · January 13th, 2012, 03:17 AM

When I select start-> SQL Server Management Studio,

I get connect to server dialog box of Microsoft SQL Server 2005

Server type : Database Engine
Server name : USER-VAIO
Authentication : Sql Server Authentication
Login : sa
Password : sa

in this dialog box i just enter password and then click connect button .
i get connected to sql server.ya its work.
left side in object Explorer pane its also shows the name of server that is:
USER-VAIO(SQL Server 9.0.1399 - sa)

but when in connect to server dialog box if i choose window Authentication from Authentication dropdown list and the click connect button i get following error.
Cannot connect to USER-VAIO

can i change setting from SQL Server authentication to window authentication??

M I using sql server 2005 express only?or its sql server 2005 commecial version?i m confused about it.that why in previous reply i added all the installed component.but my friend told its the sql server 2005 express only.
so i dont understand why i m getting error when i do try it out of book in ch-11 and further.

Imar · January 13th, 2012, 06:17 AM

Looks like you are using Express, but with an unnamed instance. E.g. your server can be reached using just a dot (.) and not .\SqlExpress

Take another look at my earlier replies and the thread I linked to for more background, and then clear the instance name field in Tools | Options as described earlier.

Cheers,

Imar

ramila · January 13th, 2012, 01:14 PM

i read the earlier thread again and in visual studio 2008 i cleared the sql server instance field by following steps.

tools-->option-->Database tools-->SQL Server Instance Name
in this text box( SQL Server Instance Name) by default SQLEXPRESS was there and i cleared that textbox

then also i m getting same error when i attach resource database PlanetWrox.mdf

error :
Required Component Missing
Connection to SQL Server files(*.mdf) require SQL Server Express 2005 to function properly.Please verify the installation of the component or download from the URL:
http://go.microsoft.com/fwlink/?LinkID=49251

Imar · January 13th, 2012, 02:53 PM

Hi there,

Then maybe you don't have the Express edition? Try this:

1. Start SQL Server Management Studio
2. Log in
3. Open a new Query Window, type SELECT @@VERSION and execute the query (F5)

My SQL Server 2005 Express returns something like this:

Quote:

whereas a standard version (2008 in my case) returns something like this:

Quote:

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

If you version does not contain a mention of the Express edition, you can use the Web Platform Installer to install it, side by side to the version you already have. If it is SQL Server 2005, I don't know what's going on... ;-)

Cheers,

Imar

ramila · January 14th, 2012, 12:45 AM

hi

i tried the steps u mentioned in earlier reply
and i got following result:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.1 (Build 7600: )

so its Developer Edition means STANDARD SQL SERVER 2005 right?

so from where i can install Web Platform Installer ?can I install it on windows 7?if i install it it will work properly for book's try it out.
or should I uninstall current sql server 2005 and again install sql server 2005 express ?

Imar · January 14th, 2012, 05:43 AM

Well, it means the Developer Edition, not the Standard Edition which is yet another version. But if by Standard you mean "not Express", then yes, this is the standard edition. ;-)

Quote:

from where i can install Web Platform Installer

Google knows these kind of things. It's the number 1 result:

http://www.microsoft.com/web/downloads/platform.aspx

Quote:

can I install it on windows 7?if i install it it will work properly for book's try it out.
or should I uninstall current sql server 2005 and again install sql server 2005 express ?

Yes. It should install a new instance called .\SqlExpress which is what the Try It Outs assume. No need to uninstall the existing installation although you could if you don't need it anymore (although it's a developer edition, you still need a paid license for it; the Express edition is entirely free).

Cheers,

Imar

ramila · January 14th, 2012, 05:51 AM

if I want to again install sql server 2005 express then which one should i install ?

Microsoft SQL Server 2005 Express Edition Service Pack 1 or service pack 2,3,4
there r many options..
but which one support window 7 and also the try it out of book

Imar · January 14th, 2012, 06:01 AM

See my previous psot: if you want to follow along with the book you need the Express 2005 edition. For other purposes you may have, you could intall other version of you have the need.

Imar