Hello all
I am relatively good with ASP.net, been making lots of websites and logins
etc etc for a while now but always using Access as a data source.
Time has come to move up to SQL Server mainly because my new venture is
massive and many people will be updating data at the same time.
I have created my website on my computer, I have created a SQL database, all
works perfectly.
Now I want to copy the website to the webserver, the Data source is a mdf
file. With access it was easy, just copy it to the server. However this does
not work with SQL data source.
Has anyone any tips for how to do this, or a link that could help? The
server is Small Business Server with all the updates, and it has a SQL Server
Service Manager installed.
What do I need to do to get it to work. The only thing I can see that might
be a problem is in the webconfig it refers to SQLEXPRESS as the database,
should it be different?
Many thanks
James
1  962 
You need to copy the MDF (and optional LDF log file) to the Database server
and use SQL Management studio to ATTACH the database. Then change your
connection string to not use User Instance, e.g.
server=myserver;database=mydatabase;uid=myuser;pwd =mypassword
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com
"James" wrote:
Hello all
I am relatively good with ASP.net, been making lots of websites and logins
etc etc for a while now but always using Access as a data source.
Time has come to move up to SQL Server mainly because my new venture is
massive and many people will be updating data at the same time.
I have created my website on my computer, I have created a SQL database, all
works perfectly.
Now I want to copy the website to the webserver, the Data source is a mdf
file. With access it was easy, just copy it to the server. However this does
not work with SQL data source.
Has anyone any tips for how to do this, or a link that could help? The
server is Small Business Server with all the updates, and it has a SQL Server
Service Manager installed.
What do I need to do to get it to work. The only thing I can see that might
be a problem is in the webconfig it refers to SQLEXPRESS as the database,
should it be different?
Many thanks
James
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Phil |
last post by:
I am using a Pascal like language (Wealth-Lab) on W2K and call this server:
class HelloWorld:
_reg_clsid_ = "{4E797C6A-5969-402F-8101-9C95453CF8F6}"
_reg_desc_ = "Python Test COM Server"...
|
by: Nathan Sokalski |
last post by:
I want to set up SQL Server on Windows XP Pro so that I can use the database
capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what...
|
by: Grim Reaper |
last post by:
My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have
never setup a server from the beginning, so I am a little new at creating
server groups.
Alright, I am trying to create...
|
by: Chris Halcrow |
last post by:
Hi
I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP.
I continually get the error 'cannot configure server' just at the end
of the installation. I've tried the following:
...
|
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
|
by: Hazzard |
last post by:
I just realized that the code I inherited is using all asp.net server
controls (ie. webform controls) and when I try to update textboxes on the
client side, I lose the new value of the textbox when...
|
by: Mike |
last post by:
Hi,
I am strugling with a simple problem which I can't seem to resolve.
I have an asp.net page which contains a server-control (flytreeview,
which is a kind
of a tree to be exact).
The tree is...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of...
|
by: Developer |
last post by:
Hello All,
i have recently installed VS2005 and was trying to install SQL sever
2000.
I have Win XP' SP2. But when I tried installing, it only installed
client tools and not the database.
Can...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
