Sql Server Express won't let us create a database (Vista 32-bit)

MS SQL SERVER

    Sponsored Links

    Next

  • 1. 2008 books
    Does anyone have any good recommendations for SQL 2008 books? I'm also looking for VS 2008 and Windows 2008 books if you know of any. Thanks in advance. Andre
  • 2. SQL 2005 Std install fails with "feature(s) not valid for this edi
    I am trying to install SQL 2005 Std on a server that is a domain controller, but not the main server in a Small Business Server domain. We upgraded SBS 2003 R2 to Premium Edition, but the SQL server turned out to be a Workgroup Edition and lacks some features that the DBA consultant promised. I am a generalist and responsible for getting SQL Std going. We are at the testing stage. SQL 2000 was installed, but I uninstalled it before beginning the SQL 2005 installation. The CDs were copied to the server and I am installing from the copies. I get all the way through selecting the options, but then install quits saying the listed features are not valid. No specific features are cited. We have a database to test and would like to get this install completed asap. -- Mikel Cook MCSE 2003

Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Wed, 07 Jan 2009 07:45:28 GMT

Hi;

We are trying to use Sql Server Express with an application of ours.
We install as follows:

1) Install Sql Server 2005 Express using the msbuild bootstrapper.
2) Run the Sql Server Express 2005 SP-2 service pack (msbuild does not
support SP-2).
3) Run a script where it starts with:
	CREATE DATABASE [AutoTag]
	GO
And on Vista (32-bit) we get:
	Msg 262, Level 14, State 1, Line 1
	CREATE DATABASE permission denied in database 'master'.

On Windows XP it works fine.

We get this problem both running the script in Sql Server Management
Studio and when running it using ADO.NET calls.

What is going on?

thanks - dave

david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

RE: Sql Server Express won't let us create a database (Vista 32-bit)

Postby changliw » Wed, 07 Jan 2009 16:17:49 GMT

Hi David,
Thank you for using Microsoft MSDN Managed Newsgroup.

I understand that you could not run CREATE DATABASE statement on Vista due 
to the permission error:
Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database 'master'.
If I have misunderstood, please let me know.

This issue should be related to UAC on Vista. I recommend that you start 
your SQL Server Management Studio and .NET application with "Run as 
Administrator" to elevate the user permission. 

Hope this helps. If you have any other questions or concerns, please feel 
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your 
comments and suggestions about how we can improve the 
support we provide to you. Please feel free to let my manager 
know what you think of the level of service provided. You can 
send feedback directly to my manager at:  XXXX@XXXXX.COM .
===========================================================
Get notification to my posts through email? Please refer to 
 http://www.**--****.com/ #notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues 
where an initial response from the community or a Microsoft Support 
Engineer within 2 business day is acceptable. Please note that each follow 
up response may take approximately 2 business days as the support 
professional working with you may need further investigation to reach the 
most efficient resolution. The offering is not appropriate for situations 
that require urgent, real-time or phone-based interactions. Issues of this 
nature are best handled working with a dedicated Microsoft Support Engineer 
by contacting Microsoft Customer Support Services (CSS) at 
 http://www.**--****.com/ 
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby Ekrem soy » Wed, 07 Jan 2009 17:36:44 GMT

> 2) Run the Sql Server Express 2005 SP-2 service pack (msbuild does not

This second item has nothing to do with the error you get and probably 
Charles has already answered that question, however I'd like to clarify it.

Service Packs can't be applied to Express Editions. Express Edition of SQL 
Server is re-released with the latest Service Pack integrated. If your 
Express Edition is RTM version, then you may want to go to Microsoft 
Download and download the lastest SQL Server 2005 Express Edition.

-- 
Ekrem soy









Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby Aaron Bertrand [SQL Server MVP] » Wed, 07 Jan 2009 23:14:03 GMT

> Service Packs can't be applied to Express Editions.

Just FYI, I was surprised the other day to find that Cumulative Update 2 for
SQL Server 2008 offered to patch my local Express instance as well as my
developer edition instance.  I was not aware of any plans to support
patching Express in this way, so maybe we can hold out hope that in 2008 we
will be able to do so with a service pack?  (I haven't run Express 2005 in a
long time, and I forget if you could apply CUs to those builds.  I guess
that would make sense but I was a little taken aback when that happened.)


Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby Ekrem soy » Wed, 07 Jan 2009 23:38:06 GMT

Ahh thanks for the heads-up Aaron. I was talking about the service packs in 
my comment because I'm certainly sure that Service Packs can't be applied to 
Express Edition of SQL Server 2005. But appearently CUs are another aspect 
of this discussion. I'll try to run a CU against a 2005\2008 Express Edition 
instance when I have some spare time for this test.

-- 
Ekrem soy









Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Thu, 08 Jan 2009 04:47:04 GMT

Teriffic - because the msbuild bootstrapper only supports the RTM
version and that works with XP which is 98% of our customers.

It looks like for Vista we need to tell people that they must install
Sql Server Express first - and handle the tech support headache when
they don't.

I sure wish MS would update msbuild...

thanks - dave


On Tue, 6 Jan 2009 10:36:44 +0200, Ekrem soy < XXXX@XXXXX.COM >





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby changliw » Thu, 08 Jan 2009 18:26:09 GMT

Hi Dave,
If you want to embed SQL Server Express into your custom application, you 
can refer to this article:
Embedding SQL Server Express into Custom Applications
 http://www.**--****.com/ 

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your 
comments and suggestions about how we can improve the 
support we provide to you. Please feel free to let my manager 
know what you think of the level of service provided. You can 
send feedback directly to my manager at:  XXXX@XXXXX.COM .
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Sun, 11 Jan 2009 05:40:29 GMT

Hi;

Thank you - that was it.

Question - why does Sql Server not allow a DB create unless you are
running as an admin? It seems to me if you are the sa user on the DB
you should be able to do anything.

thanks - dave


On Tue, 06 Jan 2009 07:17:49 GMT,  XXXX@XXXXX.COM 





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Sun, 11 Jan 2009 05:40:45 GMT

Hi;

It is running SP-2 for Sql Server Express 2005 on our Vista test
systems. Maybe they allow it for cases where the SP is required for
that O/S.

thanks - dave


On Tue, 6 Jan 2009 10:36:44 +0200, Ekrem soy < XXXX@XXXXX.COM >





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Sun, 11 Jan 2009 05:41:01 GMT

ps - How can we determine the version of Sql Server installed from the
registry? Since we are not supposed to run the RTM version on Vista, I
want a way to tell if they have SP-2 installed without running Sql
Server.

thanks - dave


On Tue, 6 Jan 2009 10:36:44 +0200, Ekrem soy < XXXX@XXXXX.COM >





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Sun, 11 Jan 2009 05:51:59 GMT

Hi;

Correct me if I'm wrong but it looks like with this approach we need
to put the Sql Server installer in our install package and then run it
if needed. This means that people are always downloading a much larger
program even if they already have Sql Server installed.

Is there a way to do this like the msbuild bootstrapper where it is
only downloaded if needed?

thanks - dave


On Wed, 07 Jan 2009 09:26:09 GMT,  XXXX@XXXXX.COM 





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby Ekrem soy » Sun, 11 Jan 2009 18:22:59 GMT

Well, it's a little bit tricky...

You can find the installed instances from the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance 
Names\SQL

After determining the instance name and folder, then you can find the 
information about the installation of this instance from the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.3\Setup

-- 
Ekrem soy










Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby changliw » Tue, 13 Jan 2009 20:24:51 GMT

Hi Dave,
Yes, your understanding is right. Unfortunately there is no way to do this 
like the msbuild bootstrapper now. You may give your feedback at 
https://connect.microsoft.com/sql so that our product team can hear your 
voice for product improvement.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your 
comments and suggestions about how we can improve the 
support we provide to you. Please feel free to let my manager 
know what you think of the level of service provided. You can 
send feedback directly to my manager at:  XXXX@XXXXX.COM .
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


Re: Sql Server Express won't let us create a database (Vista 32-bit)

Postby David Thielen » Thu, 15 Jan 2009 01:44:18 GMT

thank you

On Sat, 10 Jan 2009 11:22:59 +0200, Ekrem soy < XXXX@XXXXX.COM >





david@ XXXX@XXXXX.COM 
Windward Reports --  http://www.**--****.com/ 
me --  http://www.**--****.com/ 

Cubicle Wars -  http://www.**--****.com/ 

Similar Threads:

1.Can you run 64-bit and 32-bit SQL server on same 64-bit Server

Thank you.

"Tom Moreau" wrote:

> Yes, you can run both 32-bit and 64-bit SQL Server on the same machine.
> 
> -- 
>    Tom
> 
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
> 
> 
> "Catrina" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> I'm new to SQL Server, so please forgive my ignorance.  One project I'm 
> being
> tasked with is a SQL Server consolidation and reorganization.   In terms of
> hardware, if we have a 64bit server, could it run 2 instances of SQL Server
> (one for 32 bit apps and another for 64 bits apps) or do we need 2 different
> servers? 
> 
> 

2.32 bit SQL 2005 on x64 platform cannot access 32 bit DSN

Running SQL 2005 32 bit on an x64 server. Installed 32 bit odbc driver 
and can create a DSN but cannot see the DSN with the SSIS import 
wizard/.net odbc provider. I though 32 bit apps should see 32 bit DSNs?

3.SQL Server 64 bit linked server Error with Sql server 32 bit

Hello,
I've just setup new HP server with 4 Itanium processors and installed a sql
server 200 64 bit developer version on it. Operating system is Windows 2003
Enterprice 64 bit . RAM 16GB
I created a link server configuration to existing Sql server 2000 32 bit
running on windows 2000 advanced server.

When I try to execute distributed query
 select * from server32.dbname.dbo.table
 I get following error

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver).  Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005:   ].

Funny thing is that when i use select * from OpenQuery (...)  it works
Can anyone help
If necessary, I can provide a sql dump file (I run sql with -y7399 option).
Thanks in advance.
Artek


4.restore 64 bit SSAS 2005 database to 32 bit SSAS 2005 database

Hi Folks,

Can we restore 64 bit SSAS 2005 database  (windows 64bit, sql 64bit)  to
32 bit SSAS 2005 database  using that *.abf   xml file?

Do I need to change anything in that file?

And also how to check SSAS engine version? Is there any xmla query?

For DB engine we have the following query. 
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), 
SERVERPROPERTY ('edition')

what's it for SSAS engine?

Please help.

---Kumar


5.Can 64 Bit SQL Server 2005 replicate to a 32 bit SQL Server 2000 b

Replicating data from 64bit to 32bit SQL Server 2005 is supported.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights. 


" XXXX@XXXXX.COM " wrote:

> Crazy question, I know. We have two active-active SQL Server clusters,
> one at each of two data centers, that replicate data via SQL Server
> replication. One will be upgraded to SQL Server 2005 64 bit Enterprise
> while the other will stay at SQL Server 2000 32 bit Enterprise. Will
> they still be able replicate data to each other?
> 
> 

6. Using 32 bit SQL Client with a 64-bit Backend Database

7. Linked server 64 bit SQL SERVER - 32 bit sybase

8. Running 32-bit sql server 2005 on 64-bit Windows Server 2003



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 14 guest