Hello all!
This is my first on this newsgroup, because I am starting my adventage of MS
SQL Server 2000 Enterprise.
I have just installed this application on my local computer, but I don`t
have any Northwind training databases, on which I could try it out. Can you
tell me where I make a mistake? Can you also be so kind and tell me how can
I add this northwind database to my SQL Server 2000.
Thank you in advance for your help
Marcin
hi,could sqlexpress be installed to vista starter?thanks in advance
View 2 Replies View Relatedhi,
could sqlexpress be installed to vista starter?
thanks in advance
Hi All,
I have a problem with the Club Starter kit that I downloaded from the SQL Server Express Site. I installed the VSI into VS2005 but when I try to save the project, VS puts up a dialog with "Unable to complete Operation." The project runs OK within VS but any changes I make are lost when the app closes because it won't save.
I know this does not appear to be a SQL Server Express problem but I'm wondering if anyone else has used the starter kit and experienced the same problem, and more importantly, how to fix it.
Thanks a lot
I am unable to create the personal.mdf when I run my homepage. I get 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.
I am new at this stuff and any help will be welcomee. .
thanks
Seth
Hello,
I am trying to get Classifieds Starter Kit work in SQL Server 2005. I did following:
1. Create DBs; The sql scripts came with the starter kit in the App_Data folder.
2. To create aspnetdb: aspnet_regsql.exe -E -S localhost -A mr
3. Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols 'TCP/IP' and possibly 'Named Pipes'
4. My connections string <add name="classifiedsConnection" connectionString="Data Source=MyServerName;;User ID=user;Password=pass;Initial Catalog=ClassAds" providerName="System.Data.SqlClient" />
I still get the following error when I debug the application:
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)
How can I resolve this problem?
I have had a local Website up and running based on the MS Personal Website Starter Kit using Visual Studio 2005 Professional and SQL Server Express.
I am now trying to get the databases to run on SQL Server 2005 Standard Edition but can't get the connection to work.
I have changed the connection string in the Web.Config file from:
connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"
To
connectionString="Data Source=.scastle;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"
But 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)
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: 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)
Source Error:
Line 5: Sub Application_Start(ByVal sender As [Object], ByVal e As EventArgs)
Line 6: AddHandler SiteMap.SiteMapResolve, AddressOf Me.AppendQueryString
Line 7: If (Roles.RoleExists("Administrators") = False) Then
Line 8: Roles.CreateRole("Administrators")
Line 9: End If
I am able to connect OK in both Server Management Studio (Server Name: SCastle, Windons Authentication) and clicking Connect to Database in Server Manager in Visual Studio (Server Name: (local)).
Have I got the connection string wrong or do I need to set up additional permissions in the database?
Thanks for your help.
Stephen
During the istall of the issue tracker starter kit, im prompted ti select the type of DB. If I select MSACCESS, all is good I have " Microsoft SQL Server 2005 Express Edition with Advanced Services" installedIf I select Microsoft SQL Server/MSDE 2000 I get the following 1) Sql Server ( I select local)2) connect using a) Windows authentication - WhenI do this I get the error message "Login Failure: could not loginto server (local)" b) SQL Server authtication - WhenI do this I get the error message "Login Failure: could not loginto server (local)"Please Please help me. I have to get this going or I'm mud !!! actually , less than mud
View 1 Replies View RelatedWhen I registered SQL Server Express I received an e-mail back showing all of the resources available to get started. There were 6 Starter Kits available, Teacher, Colection Manager, Amazon Enabled Movie Collection, and three others. When I click on the links to download the Starter Kits, the link comes back as invalid. Can you provide the correct links to use to get the Starter Applications, or can you e-mail me code? Thanks for you attention to this matter.
Charlie Cappello
CIGNA
I am new to sql server express editions.
starter kits and Sample applications link provided in the sites are not working.
Can anyone provide me the alternate link where I can dwnld them from
http://msdn2.microsoft.com/hi-in/express/bb403187.aspx
http://msdn2.microsoft.com/hi-in/express/aa718396.aspx
Hi, everyone!
I'm trying to practice with the website starter kits using Visual Studio
2005. But so far, I haven't been able to run the mentioned websites because
the connection they use is against SQL Server Express...
I don't have SQL Server Express. Instead, what I have installed is SQL
Server 2005 Standard Edition.
I'm not even able to use the new APS.NET WeSAT application to administer the sites because allway get the "Time out" error.
Do any of you know how to resolve this whole situation?
Thanks very much in advance for your help.
Ralph.
1. The download links shown below for the Starter Kits found at this URL do not work:
http://msdn2.microsoft.com/en-us/express/aa718396.aspx
Teacher Starter Kit
VB http://msdn.microsoft.com/vstudio/eula.aspx?id=4d31bb50-22da-411f-b747-a7b2288fc720
C# http://msdn.microsoft.com/vstudio/eula.aspx?id=06b20449-cbba-4f2f-ab8c-b99c1266cc7e
Collection Manager Starter Kit
http://msdn.microsoft.com/vstudio/eula.aspx?id=98c8074d-d28e-49e1-be44-94f0114f372a
Club Web Site EventCalendar control source code
http://www.asp.net/starterkits/downloads/eventcalendar.zip
2. None of the download links shown below for the Sample Applications found at this URL work:
http://msdn2.microsoft.com/en-us/express/bb403187.aspx
Internet Explorer Favorites Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=3bdccf1b-88c6-45a6-9dcf-7499ad664dab
Skills Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=09305c92-890f-4dc7-a20d-f58b611d23c7
Survey Manager Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=98171070-e0f6-4fcd-948e-9c5af497ab4f
Help Desk Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=009e3b2d-98b1-46dc-8476-676a2519eafa
Reports for Web Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=79610b4f-fc7e-4ca8-9ae2-8ca8a5a6de0d
Reports for Windows Sample
http://msdn.microsoft.com/vstudio/eula.aspx?id=9c9a8d75-58b1-4be7-91be-50fefbe5d28c