Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicc
Starting Member
2 Posts |
 Posted - 2011-08-30 : 03:06:07
|
| Hello,I'm a newbie using SQL server.After installing Microsoft Web developer 2010 express, i have SQL Server 2008 express.My goal is to make a data based website. My data is stored in a relational database in MS Access. Question is how to export Access data to SQL Server?If I want to upsize my access database (only tables, restrictions and relations) I cannot pass first step in wizard: connecting to SQL Server. I got SQL errors 17 or 14.I tried 'local', 'localhost', but nothing worked so far.What am I doing wrong?grtznicc |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-30 : 11:21:19
|
| Try connecting to it via SSMS. If you didn't change the default options when installing, it will be "machineName\SQLEXPRESS" without the quotes. |
 |
|
|
nicc
Starting Member
2 Posts |
Posted - 2011-08-31 : 02:47:29
|
| After looking in SQL option, I found my servername and it worked fine. Indeed, it was "machineName\SQLEXPRESS" without the quotes.Thank you russell! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-31 : 11:23:50
|
Glad to help  |
|
|
|
|
|
|
upsizing access to SQLserver