SQL Server Express And Vista Connecting Issues...

Jul 13, 2007

Alright I glanced over the forums to see if there was an answer for this and I didn't see one. I saw a few similar issues however nothing that fixes my issue. Here is my problem.



I installed SQL Server 2005 Express on my Vista partition along with Visual C# Express. For some reason I cannot get the SQL Server 2005 Express to function correctly. Back when installed this on XP it worked flawlessly, and I don't even recall doing anything special...I installed it and it worked. I do know that you have to manually add the user account to the admin list for the SQL server on Vista, and I did that. I chose the option to have it do it during installation as well as through the SQL Server Surface Area Configuration just to be sure.

I am just trying to get the basics of it working right, and that is connecting to the server using C# and filling a dataset...it shouldn't be this hard. This morning when I started with this I could connect and fill my DataSet programmatically however it wouldn't pass the test through the Data Source Configuration Wizard. When I did it manually, as I said it worked and filled the DataSet with the info I asked for below in the code sample. After getting annoyed by it not working through the wizard I decided that maybe I had my permissions wrong and I may have messed up when installing it. So I uninstalled everything to do with SQL Server 2005 and reinstalled it fresh.

This time when I installed it I made sure to set it up to use Windows Authentication. Now it will pass the Test in the Data Source Configuration Wizard and everything is working by doing it that way. However now it doesn't work when I do it manually with the code below(same code as before when it worked...lol). When I use the code below it crashes with the 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)". When I go through it with the debugger it throws that error at the call dataAdapter.Fill(...). The code is the following:




Code Snippet

string connStr = "server=localhost;Trusted_Connection=yes;database=northwind";

string commandStr = "Select CompanyName, ContactName from Customers";



SqlDataAdapter dataAdapter = new SqlDataAdapter(commandStr, connStr);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet, "Customers");

DataTable dataTable = dataSet.Tables[0];



foreach(DataRow dataRow in dataTable.Rows)

lbCustomers.Items.Add(dataRow["CompanyName"]+

" ("+dataRow["ContactName"]+")");

Why doesn't that work yet I can basically ask for the same information and it will work if I do it through the wizard? If it works 1 way I wouldn't think there could be any issues with the server being accessed remotely, right?



Thanks

Danny B

View 1 Replies


ADVERTISEMENT

Connecting To SQL Server Express 2005 From Vista

Jan 18, 2007

Hi all,

I am having problems with connecting to a SQL Express server running on server 2003. I can connect with the program concerned from a windows xp client without problems. I cannot however connect from a vista machine using the software. In the logs i see the client trying to logon, wich fails with Login failed for user: 'user'. [client: clientIP] severity 14 state 8. On the vista client i have tried everything from disabling the firewall, windows defender, running the app as admin etc. I can connect using sqlcmd or the management tools with the username the app is using. This is a SQL user, we are not using windows users to connect to the DB.I also ran a app like ethereal to see what is happening packet wise, i see the login failed packet on a windows client, from a XP client everything seems fine and it starts using RPC.

Any help appreciated,

FVader

View 1 Replies View Related

Connecting To SQL Express On Vista Issues

May 21, 2008

I'm having issues talking to Vista Sql Express, but selectivly.

The following diagram shows you what works, and what doesn't :

http://www.craznar.com/junk/sqlissue.png

As you can see, the Vista/Express server is running - has all the required connectivity enabled, however we cannot talk from the Windows Server 2003 SQL to the Vista SQL.

The error that is given suggests issues with remote access enabling on Vista - but this is working alsoVista's firewall turned off (We can connect to it).

All machines are on the same subnet, behind the same firewall - Neptune and Headoffice are on a domain, Neptune points to Headoffice for DNS, Headoffice forwards DNS requests to the same DNS all other machines use.

File sharing and Ping work from Headoffice to Neptune ... just can't get SQL connection to work.

Any help appreciated.

Thanks

View 8 Replies View Related

Problem Connecting To SQL Server On Vista

Dec 19, 2007

I have two computers each with SQL Server Developer edition on them. Each is set up identically with remote connections enabled. Once machine is running Vista Business the other is running XP Pro SP2. From the Vista machine I can connect to the instance on the XP machine but I cannot connect to the Vista instance through the XP machine. I keep getting the error that indicates SQL Server isn€™t set up for remote connections even though it is. There is obviously some access problem that is due to Vista but I have no idea what it might be.

Thanks for any help you might provide.

Dane R. Vinson
PS I wasn't totally sure of the correct forum to post this but it seems like it might be a setup issue.

View 3 Replies View Related

Connecting To SQL Server 2000 Via VB6 Program On Vista

Jul 18, 2007

I am having difficulty connecting to SQL Server 2000 on one of ourservers via a VB6 program on Vista. I can connect fine to a differentserver, but it gives me the following error with the server inquestion:"Unable to connect to database. Please check your internet connectionError# -2147467259[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist oraccess denied"Using the program, I am able to access the database just fine whilerunning on Windows XP, but when I run the program on Vista, it givesme that error message for that server. If I change the connectionstring to a different server address, it works fine on Vista. Whatdifferences in the servers might cause this?Here is my connection string:"driver={SQL Server};Server=ipaddress;Uid=userID;Pwd=pwd;databa se=db"

View 7 Replies View Related

Connecting To An External SQL 2000 Server From A Vista Machine With SQL 2005 Installed

Nov 26, 2006

hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution.
Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site.  However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005.  I specify my connection info in the web.config - and it points to an external ip address on the web.
Can anyone shed some light on this?  I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :)
 To summarize my setup (if it helps)
Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application)
External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application)
 
 Much appreciated,
Ted
 

View 5 Replies View Related

Connecting VB Express Files To SQL Server Management Studio Express

Aug 23, 2006

Really confused ... I created 2 tables in a VB Express program (which went well). Problem is that I can't see/find those tables with MSME. I don't really understand how to connect the MSME to where the tables are. I created the tables under My DocumentsData and they are DBapp.mdf + DBapp_log.LDF and the tables are Items and Preferences. The VB application can "see" the tables OK.

Do I need to move the tables to C:Program FilesMicrosoft SQL ServerMSQL.1MSQLDATA (like the Adventureworks installation which I haven't done) or what?

Please help a newbie

Thanks

George

View 3 Replies View Related

Connecting To SQL Server 2005 Express In LAN Using C# Express

Jan 14, 2006

I tried to connect to SQL server 2005 express in LAN Using C# express

I got this msg
the file \blablabla\blablabla.mdf is on a network path is not supported for database file.An Attempt to attach an auto-named database for file \blablablalablabla.mdf failed. a database with same name is exist, or specified file can not be opened, or its located on UNC share.
 
Is that mean :
I can not connect to SQL server remotly using express edition of C#
SQL server dosen't support connection in LAN
 
I tried to set all options like enable TCP IP connection and networks
 
by the way
 
The data has unquie name and it is located in shared folder and I can easly to connect to database like access with no problem
 
I will be thankful if you can help me

View 11 Replies View Related

Vista Sql Server Express Sp2 Issues

Dec 24, 2007

I am having issues with adding a new database in vwd 2008 as i keep getting the 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 have tried most of the tips on the net already including changing SQLEXPRESS Built-in account to Local System instead of Network Service, running as a administrator and going into surface area to add new admin and adding priveledges to my account. None of these have helped.
I can create a database in the management studio but can't create it in vwd and also the asp.net applications doesn't run either. can anyone help as i have no idea what to do.
 
 

View 1 Replies View Related

SQL Server 2005 Express On VISTA

Jun 18, 2006

Greetings!

I tried installing SQL Server 2005 Express on my VISTA Beta 2 Box but before doing so, I checked if IIS is already installed and running. During the assesment of my current configuration, SQL Server 2005 Express is still looking for IIS. Are the conflicts regarding IIS 7.0 to SQL Server Express or the feature is not yet available. I will be continuing to do experiments with this one and hope there will be people who can share their experiences too.



Thanks!

View 9 Replies View Related

Sql Server 2005 Express And Vista

Aug 30, 2007

i can't install sql server express in vista, i 've downloaded sp2, and it's still not working... HELP!!!!

View 1 Replies View Related

VB 2005 Express Cannot Use SQL Server On Vista

Jun 12, 2007

I have been trying to get Visual Basic 2005 Express and Visual Web Developer Express to work with SQL Server 2005 Express. I am using Windows Vista.



I am running VB as an administrator. SQL Server SP2 is installed and working, and I can use SSMSEE to connect to it, create databases etc.



But VB and Web Developer cannot connect to it. Can anyone tell me how to get these products working on Vista (or do they in fact simply not work on Vista)?

View 1 Replies View Related

SQL Server Express Edition, Vista, And What SP

Dec 18, 2006

Hi there,



Can someone tell me what I need to get Express on Vista, I see a lot of contradictory information. Michael Otey notes in his column SP1, but then I here SP2.... Do I have something I can run today ...if not when..



Thanks.

View 4 Replies View Related

Vista + SQL Server 2005 Express Edition Help.

Apr 8, 2007

ok, today i upgraded to Vista, but i can't create database.
create database permission denied in database master. ("Microsoft sql server Error 262")
it must be the Vista thing because i don't have any problem with xp. yes, i the patch installed. I use SQl server management studio with Windows Authentication

View 4 Replies View Related

SQL Server Express - Registry Keys On Vista

Apr 19, 2007

When I install SQL Express on my XP Machine, the registry keys under local machine (ie, MSSQL.1, etc) show up, but on my Vista 64bit machine, the MSSQL.1 etc keys are not there. SQL Server still works, but the reg keys are missing.

View 1 Replies View Related

Can't Install SQL Server Express 2005 On VISTA

Jun 5, 2007

Code Snippet[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.

***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.

[06/05/07,11:30:10] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:52:13] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***
I try to install it from visual studio net professional 2005, every time it fails. Any idea?

View 4 Replies View Related

SQL Server 2005 Express On Vista Business X64

Jun 25, 2007

I'm trying to install SQL Server 2005 Express on my Vista Business x64 laptop and during install I keep getting the message:

- ASP.Net Version Registration Requirement (Warning)
Messages
ASP.Net Version Registration Requirement

Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).

View 6 Replies View Related

Sql Server 2005 Express Edition On Vista With 2 Cpu

May 31, 2007

Is it possible to install sql express on a 2 cpu Vista pc, even though this is stated to NOT be supported, by assigning CPU affinty, e.g., something similar to c:windowssystem32cmd.exe /C start /afinity 1 notepad.exe?

View 5 Replies View Related

SQL Server Express With Windows Vista Business?

Sep 6, 2007

Hi y'all,
I just know that SQL Server Express Edition SP2 is being released by Microsoft recently, and from previous informations I gathered; it seemed that SQL Server 2005 Express Edition is not compatible with Windows Vista (any editions).
With the release of SP2, does this mean SQL Server 2005 Express Edition is now compatible with Windows Vista?
If so, do I have to install .NET Framework v2.0 first in my Windows Vista Business edition? BecauseI know that Vista Business edition already has .NET Framework v3.0 in it.
Thanks for your help! Appreciate it...

View 14 Replies View Related

Unable To Install SQL Server Express (SP1 Or SP2) On Vista

Apr 3, 2007

I am unable to install Business Contact Manager for Outlook 2007. I sought help in the BCM forum, but the developer who I spoke with came to the conclusion that it is a SQL Server Express problem that I am experiencing, and so he recommended that I come here for help.

I am running on Vista Ultimate.

Every attempt I have made to install BCM (and later SQL Express Server 2005 separately, see below) has failed at the same point, with the same error message:

"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Today I attempted to install SQL Express Server SP2 separately on its own, the idea being that if this worked, then I might be able to install BCM on top of it. I attempted the SQL EE SP2 installation after uninstalling all remnants of previous installations to the best of my ablity. The SP2 installation failed at the same point, and had the same appearance, as I saw in all prior attempts. (The installer reported no errors or warnings in its system checks prior to beginning the actual install.)

Here is the summary log from this trial:


Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Tue Apr 03 15:39:02 2007 Machine : LUMACRAFT-1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1Product : SQL Server Database ServicesError : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.--------------------------------------------------------------------------------Machine : LUMACRAFT-1 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------

The pertinent section from the SQLSetup0008_user_SQL.log seems to be:

MSI (s) (F0:88) [15:42:00:403]: Invoking remote custom action. DLL: C:WindowsInstallerMSI118F.tmp, Entrypoint: Do_sqlScript<Func Name='LaunchFunction'>Function=Do_sqlScript<Func Name='GetCAContext'><EndFunc Name='GetCAContext' Return='T' GetLastError='203'>Doing Action: Do_sqlScriptPerfTime Start: Do_sqlScript : Tue Apr 03 15:42:00 2007Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Apr 03 15:42:00 2007SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Tue Apr 03 15:42:05 2007SQL_ERROR (-1) in OdbcConnection::connectsqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Error Code: 0x80074818 (18456)Windows Error Text: Source File Name: libodbc_connection.cppCompiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcConnection::connect@connectSource Line Number: 148---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsOriginial error was 80074818 (18456)iptSqlScriptHlprError Code: 18456Other things that I have tried include disabling UAC, and running BCM setup.exe 'as administrator'.

Any advice on how to get SQL EE installed, so that I can ultimately install BCM, will be greatly appreciated.

Thanks,

David A. Gilmour

View 6 Replies View Related

SQL Server 2005 Express &&amp; Vista Installation

Sep 1, 2006

Hi

I have installed the Beta version for Windows Vista and installed VS 2005 for Software Developers which includes SQL Server Express.

When installing the SQL Server express part compatibility issues appear. Do i need to install a fresh copy of SQL Server Express which inlcludes Service Pack 1?

I cannot connect to any mdf file through the data connection section in the VS 2005 IDE. Cant remember the exact error message, something like "Cannot find the entry or starting point".

I am running a fresh install off the latest Dotnetnuke starter kit and get a database compatibility error so my guess is this could also be as a result of SP 1 not being installed?

Any help or suggestions appreciated.

Thanks

View 7 Replies View Related

SQL Server 2005 Express Install On VISTA

Feb 9, 2007

I have a new laptop with VISTA. I've enabled IIS with all features turned on. When I install SQL Server 2005 Express I get a warning stating IIS is either not installed or disabled. Any ideas? Thanks.

View 4 Replies View Related

Sql Server Express Compatibility With Windows Vista???

May 1, 2007

Sorry.. but.. sql server express has compatibility with windows vista????

View 1 Replies View Related

Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client

Apr 5, 2007

I am trying to install SQL Server Express - (the non ADV version) and get the following error.

"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".



I have 64 bit Vista Ultimate running on an HP dv9000.

I am using the download from the bottom of the download page for SSX where it says 64 bit version.



Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.



I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.



I would appreciate being pointed at the right downloads for what seems to be a simple install.

View 5 Replies View Related

Problem Running Sql Server 2005 Express On Vista

Aug 20, 2007

I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine.  It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages.  So although it seems to be installed, I can't really use it.When I try to create a new database I get: TITLE: Microsoft SQL Server
Management Studio Express

------------------------------

Create failed for Database
'practice'. 
(Microsoft.SqlServer.Express.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

CREATE DATABASE permission denied in
database 'master'. (Microsoft SQL Server, Error: 262)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------

 When I try to attach an existing database I get:  

TITLE: Microsoft SQL Server
Management Studio Express

------------------------------

Failed to retrieve data for this
request. (Microsoft.SqlServer.Express.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while
executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The server principal
"Dave-PCDave" is not able to access the database "model"
under the current security context. (Microsoft SQL Server, Error: 916)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------

 I have tried following the links in the error messages but the result is: "We're sorry

There
is no additional information about this issue in the Error and Event
Log Messages or Knowledge Base databases at this time. You can use the
links in the Support area to determine whether any additional
information might be available elsewhere."I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet).  Any suggestions on how to proceed? 

View 4 Replies View Related

Unable To Connect - SQL Express On Server 2003 From Vista

Nov 19, 2006

Getting error 1326.

I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).

I'm trying to connect from SQL Studio Express on Vista.

TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.

I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?

Thanks, John

View 1 Replies View Related

Vista 64 Bit Machine With 64 Bit Version Of SQL Server Express 2005

May 28, 2008

Hi

I have a PC running the 64 bit version of vista home premium (will be soon upgrading to ultimate).

On the download page http://msdn.microsoft.com/en-au/express/bb410792.aspx for SQL Server Express under the section entitled SQL Server 2005 Express Edition SP2 it mentions at the bottom of the page (referred by * & **) that there is a 64 bit install version available for both SQL Server & management Studio.

However, under the section entitled SQL Server 2005 Express Edition with Advanced Services SP2, there is no * or **. As far as I can tell, the Advanced services has Reporting Services as well.

So, what I am wondering is, can I specifically download the 64 bit versions of SQL server express & management studio and as well, download just the reporting services part of Advanced Services?

Kind regards

Ross

View 1 Replies View Related

Problem Restoring Database On SQL Server Express '05, Vista

May 6, 2008

Hi All,
I have an issue that's stopping me restoring a database on SQL Server Express 2005 running under Windows Vista. I'm installing a system that I've used several times before on other systems and part of the installation procedure is to use the 'restore' function to install a database from a backup file. So I'm essentially restoring but to a db that doesn't yet exist in my SQL Server, this normally goes without a hitch. However on attempting this on a Vista system, I get the following error message -

System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLiCasework.mdf'. (Microsoft.SqlServer.Express.Smo)

where iCasework is the name I've given in the restore dialogue as the DB to restore to (which as I said, doesn't exist at the moment).

Things I've tried so far: -
I have a feeling this is down to a permissions problem, so I've tried the following already
1) Running Management Studio Express as Administrator - exact same error message
2) During the initial install, I set up the default admin user to use SQL Server authentication, having read threads about vaguely similar errors I used the Surface Area Config tool to add my windows login as an admin with admin rights and tried connecting to the Server with those credentials then running the restore - exact same error message

and

3) I also tried manually creating an empty db called iCasework and then restoring the external backup into that existing backup, which just gave a different error stating that the backup file didn't match the structure of the existing db. I could create the whole db structure manually but that would entirely negate the purpose of restoring from the backup and, more to the point, has never been necessary on any other system we've done this one.

Has anyone got any ideas that I could try next please?

View 7 Replies View Related

SQL Server Management Studio Express Support Vista ?

Mar 22, 2008

I cannot copmlete the installation because the error prompted as "Install error and error code is 29506".

Is it cannot be supported Vista ?

Best Regards
KennethCCL

View 1 Replies View Related

SQL Server 2005 Express SP2 On Vista RTM Fails To Install

Nov 18, 2006

When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:

SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL_ERROR (-1) in OdbcStatement::execute_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401)Windows Error Text: Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug 2 16:21:02 2006 Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.

TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.

Any suggestions on how to get SQL Server to install on Vista?

View 4 Replies View Related

Transerfering Development From MS SQL Server Windows2003 Server To SQL Express On A Vista Machine?

Mar 23, 2008

Hi all Pros I am transfering from windows2003 server and MS SQL 2000 to Windows Vista and SQL Express ...... Before I allways created a database manually and I could allways use as many databases I needed so in that way I could have several versions of a database for a certain software during development. Can you use separeted databasenames when developing in SQL Express? I am using a dotnetnuke installation file and inside the project there is a file /App_Data/Database.mdf should this file be renamed everytime I make a new testinstallation or setting up a separate dev environment /Johan
 
[Moderator Edit: unrelated links removed from post body.]

View 2 Replies View Related

SQL Server 2005 Express - Vista - Invalid Object Name '#spdbdesc'

Apr 2, 2007

I'm running Vista Business edition on 2005 Virtual PC.Installed SQL Server 2005 Express latest download, with instance ofMSSQLSERVER and service accounts running under "NT AUTHORITYSYSTEM".Mixed mode authentication specified and sa password specified.Used server manager to create user login with sysadmin role.Login using windows authentication.Run my application and database is created and populated with defaultrecords.However, my application executes the stored procedure "sp_helpdb"which fails with "Invalid object name '#spdbdesc'" error.If I run a query in server manager to execute same procedure loggedinas the same person it runs ok and returns a table of information.All this was working ok on XP with MSDE2000A previously.I'm programming in .NET C# CLR2.0, any body know what's going wrong?

View 3 Replies View Related

SQL Server Express Installation Fails On Vista Home Premium

May 8, 2007

I have recently updated from XP to Vista Home Premium. Now when I try to install SQL Serve Express SP2 I get :



"setup has detected problem with .net framework installation
and cannot proceed. Microsoft .net framework 2.0 is either not installed or
is corrupt."



I have tried to run sfc /scannow to make sure my .NET 2.0 was not corrupted and also was running as an administrator but could not get it installed. Anyone has any ideas?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved