Hi,
I have developed a website from the model "Starter kits Classified". Well,
the application works good, no problem in my development environment. It
uses a SqlServer 2005 express database (using *.MDF files).
But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to the
IIS/Default website/MyApp (files in c:\inetpub\wwwr oot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx, Runtime
login = ASPNET (without admin rights), Windows integrated authentificatio n
activated.
Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.
Any ideas to help me please?
Thank you !
2  1815 
As long as SQL Express is also installed on the machine, then you are
probably right that it is a access problem (I say that rather than access
rights as there is a prime reason for failure that is not "rights" based).
Check and make sure you have a protocol other than in memory (configuration
tool). That will cure most problems. In some instances, you also have to
turn on SQL Browser. That cures another group. In some instances, you will
also have to add users to SQL Server and give rights to the database, as
well.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA http://gregorybeamer.spaces.live.com/
*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"TTT" <no@no.nowrot e in message
news:45******** *************** @news.free.fr.. .
Hi,
I have developed a website from the model "Starter kits Classified". Well,
the application works good, no problem in my development environment. It
uses a SqlServer 2005 express database (using *.MDF files).
But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to
the IIS/Default website/MyApp (files in c:\inetpub\wwwr oot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx,
Runtime login = ASPNET (without admin rights), Windows integrated
authentificatio n activated.
Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.
Any ideas to help me please?
Thank you !
As long as SQL Express is also installed on the machine, then you are
probably right that it is a access problem (I say that rather than access
rights as there is a prime reason for failure that is not "rights" based).
Check and make sure you have a protocol other than in memory
(configuration tool). That will cure most problems.
I dit it
In some instances, you also have to turn on SQL Browser. That cures
another group.
I did it also..
In some instances, you will also have to add users to SQL Server and give
rights to the database, as well.
How to do it?
>Hi,
I have developed a website from the model "Starter kits Classified".
Well, the application works good, no problem in my development
environment. It uses a SqlServer 2005 express database (using *.MDF
files).
But, when i try to copy it to a IIS website, it dosent work.
- I created a website called "MyApp" under IIS (windows xp pro)
- I copied all the files from my "Visual Studio Express 2005 Web dev" to
the IIS/Default website/MyApp (files in c:\inetpub\wwwr oot\MyApp)
- I setup ASP.NET config : ASPNET v2.0, default page = Default.aspx,
Runtime login = ASPNET (without admin rights), Windows integrated
authentificati on activated.
Results : the login page (login.aspx) works, but it doesnt connect.
It seems that the ASPNET user cannot connect to the Sql server database.
For me it's a mater of access rights to SqlServer 2005 from IIS.
Any ideas to help me please?
Thank you !
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Rob Meade |
last post by:
Hi all,
I have installed VS2005 in an attempt to start writing some nice new .net
2.0 pages....alas...
Running on a laptop - XP Pro - I have Frontpage Server Extensions Installed,
O/S is all patched up to the hilt etc..
When I try to either create or open a website on the local host I get an
error telling me how Visual Web Developer cannot create/open a website on a
|
by: musosdev |
last post by:
Hi guys
I'm trying to migrate to VS2005... I've managed to do that, but realised I'd
opened my web projects as file projects, and I'm getting the error about
network BIOS command limit.
Anyway, I decided to have a go at loading them as web projects from our
Win2k3 server. It gets so far and then says "The web server does not appear
to have FrontPage server extensions installed".
|
by: Brad |
last post by:
I have a win2003 server workstation with multiple webs, each web has it's
own ip address. In VS2005, if I select to open an existing web site, select
Local IIS, the dialog correctly displays a list of all of my webs, however
if I attempt to open a site under and web other than localhost I receive the
message:
"Unable to open the Web 'http://localhost/anywebappname'. The Web
'http://localhost/anywebappname' does not exist"
Obviously...
|
by: jacky kwok |
last post by:
Dear All:
In VS2005 WebSetup installer InstallAddress dialog, there is field to
let user to select which website to install the webapp (if there are
more than one WebSite in the IIS).
I want to know how can I get the WebStie info in the customAction.
I can use "/VDIR=" in customActiondata to get the installed
VirtualDirectory.
|
by: Greg P |
last post by:
I know this is a long post, please bear with me. I have been working on
this all weekend to no avail although I have done a good amount of research
(see most pertinent links that I've looked at below). Please help me get
through this!!!
I'm having some serious problems attaching a .mdf file and accessing it. I
have a WroxUntied.mdf that I want to attach and then run the website that
uses it. This is a .mdf file from wrox books. This file...
| | |
by: ohnoonho |
last post by:
Hello,
I posted this in the C# group but thought maybe the better place would
be here since it is happening with website projects so please forgive
any cross posting.
In my website projects I can set a breakpoint, run the app, the
breakpoint gets hit, and I can step through or check some variables or
what not, and if I hit stop it appears that the rest of the method (and
any calling method) continues to execute. I know this because...
|
by: Kivak Wolf |
last post by:
Hey,
Not sure how to explain this. But I created a SQL server database file
called "testingData.mdf" using VS2005 and I connected to it. After I
create it, I can modify it, connect things to it such as my gridview.
However, when I preview the page in the browser, it says that some
other program is using it an it cannot. I solved the problem by
disconnecting VS2005 from the database. It showed the information
perfectly. The problem is...
|
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 anyone please help me with this as I want to install SQL server and
also wouold be grateful, if you can suggest me any workaround to
dealwith this problem.(Like should I install any new OS etc).
Any help would be appreciated.
|
by: Ryan Liu |
last post by:
I have this problem: "cannot continue edit while debug in VS2005".
I see the same tread after I search this topic in google, but none solutions
works for me. So again, I ask here. Can someone give a hand?
Has MS fixed this in VS 2005? Is is fixed in VS 2008?
Thanks,
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
