I am trying to convert an Access backend database to SQL Server for my
first time and I am trying to use the Access upsizing wizard. On the 2nd
screen it asks for the login and password of an account with CREATE
DATABASES priviledge on the server. Where do I find or create such an
account? Is this an account on the computer or an account in SQL Server? I
have SQL Server Express on the computer.

What version of SQL Server Express are you using?
And what version of Windows are you using?

Generally, if you installed SQL Server Express on a computer on which you
are the administrator, then you have access as a SQL Server administrator.
But if you installed SQL Server 2008, then it asks you who you want to be an
admin, so maybe you're not.
And if you installed SQL Server 2005 and are running Vista, Windows 7, or
Windows Server 2008, you might have to run as administrator to get admin
permissions.
I don't know if the upsizing wizard lets you leave the login and password
blank, so that you can use your Domain login.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Robert" <cpq1bcleREMOVEERMVOE (AT) yahoo (DOT) com> wrote

I have SQL Server 2008 Express and Windows XP Professional.

If you leave the login id blank there is no Next button to go to the
next screen.

If I put "(local)\SQLEXPRESS" in the What sql server would you like to
use for this database? and "User" in the login id field and leave
password blank I get

Connection failed
sql state 28000
sql server error 18456
microsoft odbc sql server driver sql server login failed for user 'User'

I I put "sa" in the login id field and leave password blank I get

Connection failed
sql state 28000
sql server error 18456
microsoft odbc sql server driver sql server login failed for user 'sa'



"Rick Byham, MSFT" <rickbyh (AT) microsoft (DOT) com> wrote in
news:#kHfRMopKHA.3776 (AT) TK2MSFTNGP04 (DOT) phx.gbl:

Robert (readydougREMOVEERMVOE (AT) yahoo (DOT) com) writes:
Obviously, we don't know your passwords, so we can't help with that.

But note that by default SQL authentication is not enabled, so you
would need to enable it first.

Then again, you should be able to select Windows authentication, but I have
never seen the upsizing wizard, so I don't know whether you actually can.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx