SQL Login Control Works From Dev Environment But When I Deploy The Website It Errors

Mar 27, 2006

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 

-This is the error that is being generated once the site is hosted. If I run my code from my machine and access my remote sql 2005 database it works fine. It is when I try to login from my URL directly that I get the error. Any thoughts?

Thanks.

 

John

View 2 Replies


ADVERTISEMENT

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

How Can I Deploy My My Sql Database Files Of My Website

Aug 3, 2006

Hi all,

How can I deploy my website sql database files, which I have done using Visual web developer. (Visual Studio .net 2005)

Connection srting all these are different in this VWD.

<connectionStrings>

<add name="GoalConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

View 1 Replies View Related

Possible To Deploy Website Applications Using MDF Database File?

Nov 26, 2007

Hi,A quick question, is it possible to deploy a website on a shared hosting environment which attaches to a MDF database file stored in the App_Data folder? 

View 1 Replies View Related

Cannot Deploy Reports To Default Website Get Error Msg..

Mar 29, 2007

Cannot deploy reports to default website get error msg..

'A connection could not be made to the report server http://localhost/ReportServer'

additional information:
The request failed with http status 400: Bad Request. (Microsoft reporting Services Designer)

View 6 Replies View Related

Sharing Website(asp.net) Mdf Database On A Network In Multiuser Environment

Sep 19, 2007

simple question:

I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:

c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server

i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message


System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

i read that sql server did not support database sharing with mapped drive or unc share.

So how can i share website database with c# application???

Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.

View 7 Replies View Related

Deploy Website With Create User From SQLExpress To SQL 2005

Apr 13, 2007

I'm brand new to web and ASP programming, but experienced with VB/VB.NET and SQL Server 2000 programming.  I followed a tutorial and built a little website that lets you create a user login, login and change your password.  I built this in Visual Studio 2005 using VB code and my understanding is that the site uses a SQLExpress database.  There's an aspnetdb.mdf and .ldf file in the App_Data folder.
 I want to deploy the website to a web server that is hosting SQL Server 2005, not express.  Can someone be explicit about steps to take in order to do that?  I've been trying a number of things in the web.config file, but I cannot seem to make a connectionstring that works.  I also don't know what to do with the .mdf and .ldf files from the development server--I'm thinking they should not be deployed.  Thanks for anything.
 

View 1 Replies View Related

SQL Server Error - Trying To Deploy Personal Website Package

Apr 20, 2007

After using FTP to transfer my site to Dotster, I get an error upon running the site. Here are the source error and stack trace respectively:
Line 5:  void Application_Start(object sender, EventArgs e) {Line 6:  SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);Line 7:  if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");Line 8:  if (!Roles.RoleExists("Friends")) Roles.CreateRole("Friends"); 
[SqlException (0x80131904): An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
The host provider says I must create the database [on their server] using their on-line utility, Is this true? Or do I need to configure the server to allow remote connections? If the latter is true, how is it accomplished?
Thanks in advance.... any help is appreciated.
 

View 4 Replies View Related

Problems Publishing My Personal Website - Works Fine Locally!

Jan 24, 2006

People,I'm trying to publish my first website and am having a few problems.I've got Visual Web Developer 2005 Express and am trying to use the Personal Website Starter Kit. (my SQL server is SQL Server Express Edition 2005 - which is also running on my local machine)It seems to work fine when I run it on my localhost, as soon as I ftp it up to my web hosting company, I get an error message (see below) :-An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My hypothesis is :-It would appear to me that when running locally, the starter kit website uses my installation of SQL 2005 Express Edition, but when I upload all the files, I'm guessing the application is still trying to point at a local instance of SQL on my local PC which it now cannot see. I'm guessing I need to somehow upload the SQL database onto my web host (I've purchased 100M of SQL Server 2005 space), and point the application at that SQL instance instead. But I don't know if I'm right about all this, or indeed how to do it if I am. Can anyone help?Much thanks in advance,Will

View 1 Replies View Related

Recovery :: Backup File Works Fine From Network But Not When Moved Into Sandbox Environment

Dec 3, 2014

We have a valid full backup of a database. We know it is valid, we have restored it twice from the network with no problems, but we do not have access to the network location from our sandbox environment.

The .bak file is sizable at about 9GB. The .bak file resides on our internal network, in a SAN drive. No problems there. When we copy the file from there into a sandbox environment to attempt the restore in the sandbox environment it gets corrupted. We've tried three different times and all three different times it gets corrupted. First time we copied the file over to the sandbox the restore went up to 50% and failed. The second time we copied the file again and attempted the restore again it failed at 70%.

The third time it failed at 60%. The error message we get during the restore is "...Read on ... failed: 13(The data is invalid) Msg 3013, Level 16, State 1, Line 1 Restore database is terminating abnormally."

Now some background here. To move the file our network team is doing this: they have this .vmdk file that they mount out in our production environment (which has access to the network location where the .bak file is), copy the file into the drive, then move the .vmdk file into the sandbox environment(which does not have access to the network location), mount the drive in the sandbox environment, and then I have access to the .bak file from within the sandbox environment.

Something in the process of using the .vmdk file to move the .bak file from production into the sandbox is causing the file to get corrupted.

View 13 Replies View Related

Deploying A Website With User Authentication - Getting Errors

Nov 26, 2007

I have built a site that uses form-based authentication. Am I correct in assuming that the users and passwords will be stored in the SQLServer database in the aspnetdb.mdf file?  The website works great and the authentication works how I want it to.  However, I've tried to copy over the file onto a remote machine. The first page is a login screen and this is displayed without any problems but as soon as I attempt to log in I get an error message of:An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that under
the default settings SQL Server does not allow remote connections. (provider:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)I'm wondering if this is something to do with the fact I installed SQLServer Express edition on the remote machine. The website works no problem on the local machine in debug mode of Visual Studio 2005 (Professional Edition).  I followed instructions to enable remote connections on SQLServer Express from a Microsoft support doc.  If anybody can point me in the right direction I'll be very grateful as I've hit a wall here.

View 3 Replies View Related

Login Fails When Using IIS With The Login Control And Default ASP.NET Provider

Aug 23, 2006

Hello,
I am currently trying to use the Login control in an ASP.NET website with IIS. The control works fine when I am running the website in debug mode within Visual Studio 2005. However, when I create the Virtual Directory in IIS, and try to log in from there, I get an error message as follows:
Cannot open user default database. Login failed. Login failed for user 'machinenameASPNET'
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'machinenameASPNET'.
The application is very simple. I created a Login.aspx page with a login control on it, and I have the default.aspx page. I used theASP.NET administration tool to change the authentication mode to AspNetSqlProvider (forms authentication), and to create one user (no roles). I am using the default provider with the aspnetdb.mdf database. I have been working on this for a few days now, and have searched this site but have not found a solution that works for me. Any suggestions?
Jen

View 6 Replies View Related

Classic ASP Errors Out Only In Production Environment With EOF Error

Oct 1, 2007


Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'EOF'

Used the same connection string and DSN (i.e pointing to the same database/server) in both environments. ASP works in Test Environment. Fails in Production Environment.

Test and Production have same versions of software.

Environment Details:

OS: Windows 2003 SP2
MDAC: 2.8
Database: HP Neoview

Any help appreciated.

Thanks,

Venkata.

View 1 Replies View Related

Asp Website Login With Sql?

Dec 25, 2007

I wanted to make a login for custom content on my asp website. I installed 2005 sql, gave it a named instance(sql34). I set the connections to local and remote for tcp only in the "surface area config", and made the tcp enabled in "sql manager". All of the sql services are started. So i open up the "server management studio" and it prompts me for a connection. I sellect "database engine" because thats what i installed. I typed the server's name in the "server name" and select sql server authentication for the "authentication", and use my username and password for the login.
Then I get a message cannot connect:
the default settings sql server does not allow remote connections(provider:named pipes provider,error:40-could not open a connections to sql server)(microsoft sql server, error:2)
What is the deal with this?

Another problem was i saw the sql express does not integrate with the real sql 2005. So how do i make mywebsite's web.config(express edition) to integrate for my real sql 2005 server?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

View 1 Replies View Related

Insert Works, But Delete And Update Don't In A DetailsView Control

Mar 28, 2008

I have 2 Gridviews and a DetailsView for each GridView. The first Gridview and DetailsView work fine and I can Insert, Delete and Update the DetailsView just fine.  However the second Gridview/DetailsView will only let me Insert but not Delete or Update.  When I click on the "Delete" button it just ignores me.  If I do an "Edit", when I try to click on the "Update" button it is ignored again and I have to click on "Cancel".  I don't get any error messages...
 
Anyone have an idea what might be wrong?

View 4 Replies View Related

Login Page Just Refreshes With ASP.NET 2.0 Login Control

Dec 7, 2006

I am try to login using the ASP.NET 2.0 Standard Login Control. When I enter the correct userId/Password and hit the Login button, the page just refreshes, no error is displayed. But if I enter wrong userid/password..it give me an error.

Also I check the Membership.ValidateUser() returns true, that means the user is validated, but still I am able to redirect to ReturnURL.?

Is there something wrong with the Authentication, or Creating a cookie. Can somebody shed some light on this,

I have the following machine configuration

Windows XP Pro Service Pack2
IIS 5.1
SQL Server 2000
Visual Studio 2005
DISABLE ANONMYOUS ACCESS IN IIS
ENABLE WINDOWS AUTHENTICATION

I am getting the following output :

Membership.ValidateUser(Login1.UserName, Login1.Password) : - True
HttpContext.Current.User.Identity.Name : - // is blank
User.Identity.IsAuthenticated :- False
User.Identity.AuthenticationType :- // is blank

NOTE : The applicationName is same in web.config as well as in the aspnet_Applications table in SQL Server 2000 membership database.

View 1 Replies View Related

Two Different Login Pages In One Project (website)

May 28, 2007

Hi everyone,,
 i have two different login pages in one project which are admin login and student login and they are secure by using the following function in each login page:-
 
Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click
        lblMessage.Text = ""
        If CheckAdminLogin(txtUsername.Text, txtPass.Text) Then
            'If user is valid, then redirect back to original page
            ' and setup authentication cookie
            FormsAuthentication.RedirectFromLoginPage(txtUsername.Text, False)
            'FormsAuthentication.SetAuthCookie(txtUsername.Text, True)
            'Response.Redirect("~/AdminHome.aspx")
            'FormsAuthentication.RedirectToLoginPage(txtUsername.ResolveUrl = "AdminLogin.aspx")
        Else
            'If user is not valid, then display error
            lblMessage.Text = "Invalid Credentials. Please try again"
            lblMessage.Visible = True
        End If
    End Sub
    Function CheckAdminLogin(ByVal sUserName As String, ByVal sPassword As String) As Boolean
        'Declare variables
        Dim sSQL As String
        Dim objDataCommand As SqlCommand
        Dim objConnection As SqlConnection
        Dim iTotal As Integer
        Const connectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MCHQ.mdf;Integrated Security=True;User Instance=True"
        'Create connection and open
        objConnection = New SqlConnection(connectionString)
        objConnection.Open()
        'Build SQL to count no of valid empoyees found with credentials
        sSQL = "Select count(Username) FROM Admin_Profile " & _
            "WHERE (Username = '" & sUserName & _
            "' and Password = '" & sPassword & "')"
        objDataCommand = New SqlCommand(sSQL, objConnection)
        'Execute query and return count (iTotal) of valid records
        iTotal = objDataCommand.ExecuteScalar()
        'If count is 1, then user is valid
        If iTotal = 1 Then
            Return True
        Else
            Return False
        End If
        objConnection.Close()
    End Function
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Response.Cache.SetNoStore()
    End Sub
    Protected Sub txtUsername_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtUsername.TextChanged
        lblMessage.Text = String.Empty
    End Sub
End Class
 the problem is that when i run the website it gave me an error on the path which is looking for the login.aspx only and actually i didn't create this page..
Server Error in '/MCHQ' Application.



The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly. Requested URL: /MCHQ/login.aspx

View 3 Replies View Related

HELP! Reset Dbo Login Id Password, Cannot Get Company Website Up

Mar 2, 2007

Our company website runs off of Microsoft SQL Server. Someone tried changing the 'administrative' password but the way that they did it locks us out of the database.

Under Enterprise Manager there is a Security group, underneath here is a login. The person reset the password here on the login id that is the DBO for our website's database. Underneath the database in Enterprise Manager the dbo uses this login id. Where else does the password need to get reset in order for that login id to access the database? We cannot set it back to the previous password because it is unknown.

When we go to our website we get the following error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect


Please try the following:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

View 3 Replies View Related

Login On Deploy A Report

May 6, 2008

I have a report for reportserver. The preview is ok, the build is ok but when I made the deploy, I need a login, but I do not know what is this login Where I can change this login?

View 5 Replies View Related

Login Problems Using .net 2 Login Control

Nov 1, 2006

Hi There, I have a really strange problem. I am creating a website with an administration back end. We have a seperate sql 2000 server which we are using hold authentication credientials (after having used the aspnet_regsql.exe to setup the appropriate tables. When testing the application on the local machine, everything works fine. The web admin works, I can login, I can retrieve data to display on the rest of the site. Once uploaded to the live environment things change.I can still connect to the sql server i.e. I have information being displayed on the public area of the site which is coming from the sql 2000 db. I can type in the incorrect login details to the admin section of the site and the system will return an error, which is correct as well, however, if I type in the correct login information, the page hangs for awhile and then displays this error: My question is, why is it doing this when it works find on my local box and the DB connection is actually working on other parts of the site? Can anyone help?An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

View 4 Replies View Related

Linked Server Errors After Failover But Works When It Is Failed Back

Feb 15, 2008

We are using SQL Server 2005 (9.0.3054 on Windows 2003 RC2 SP2 with clustering two instances. We are running an instance on both boxes.
I have 2 linked servers to the same server on the first box (SQL1C) that use different SQL Logins to connect to the same box but to different databases. One uses the name of the server and one uses the name of the server with a 2 at the end of it. (servername and servername2). The second linked server was added recently and is used very frequently by the new application. The other thing is there is a server with the name servername2. They are SQL boxes but I am not sure what version or what they are running on. If it turns out to be important, I will ask.

Here's what is happening:
When we fail over to the second box, up until recently, we had no problems. All linked servers worked well. But since we have added this new linked server, when we fail over, the linked server no longer works and we get an error like from the Cold Fusion application:

[Macromedia][SQLServer JDBC Driver][SQLServer]TCP Provider: An existing connection was forcibly closed by the remote host.


I got a similar error in EMS, but did not copy it to save it. Since this is a production server, I can't really just try things.

We checked to make sure all IPs from box1 and box2 are allowed access to the server and they are not using IP blocking for inside the university domain.

There are no errors in the SQL Logs. I checked the application logs and found no errors for the linked server. The only error I could find and I didn't think it was related but I will include it was this:


Closed event notification conversation endpoint with handle '{4F54167A-F3D0-DC11-97FE-000E0CB2D7CA}', due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8470</Code><Description>Remote service has been dropped.</Description></Error>'.


Any ideas? One of our pplications goes down when the cluster fails over now. Help PLEASE!

Thanks,
Linda

View 7 Replies View Related

SQL Server 2014 :: SSRS - Reporting Website With Login Details

Nov 28, 2014

I need to create a website which has login details and then shows a list of reports for my clients?

Clients are external so would be website based with a login screen.

View 1 Replies View Related

Troubleshooting Errors When Using The Reportviewer Control

Mar 29, 2007

Is there some way of troubleshooting errors when using the reportviewer control (with no reportserver).? Specifically, I am dynamically loading supreports and their ascociated datasets. I get an "Error: Subreport can not be shown." in the report viewer display panel at run time. In the past when I have gotten them it was a matter of randomly trying things until I hit on the problem. I can trace it to the point where I load the dataset for the subreport and all seems correct. There are no report parameters to be passed so I know its not that. I've double checked the subreportname,datasource and dataset names and they are all okay.



Any help would be greatly appreciated.

View 4 Replies View Related

Trapping Errors In The Control Flow

Mar 1, 2007

SSIS GURUS:

I have read several posting about various modes of trapping errors, but none seem to directly address what I am looking for (SQLIS.com.MSDN, etc)



Coming from a Java/C# background, I am looking for a way to trap errors that arise within the ssis control flow much like the said languges:

try {

do something

} catch(AnExceptionType myException) {

handle my exception

}

/ ** my code at this point is unperterbed by the exception unless I explicitly raise the exception out of the scope of the exception handler. */

To make the analogy in SSIS, I want to be able to handle an error within a "container" and not have to handle the same error in surrounding containers.

Example:

I have a "Foreach" container (call it container FEC) that contains several other containers. One of the subordinate containers is a "For Loop" (call it FLC). The FLC in turn has some nested tasks, some of which are expected to fail and therefore I want to handle in a graceful manner. The tasks that are expected to fail have a "fail" constraint that links them to a task that I want to occur when the failure occurs, and that works, but the failure is not trapped as it percolates out of the container to the FEC. I also tried to trap it with event handler, but that is also an incorrrect trail to follow.

I don't want the failure to percolate up to the FEC. I have set the max errors to a reasonable value for FLC and my "program" is not exceeding that value; however, the FEC still sees that error so it fails. How do I keep FEC from seeing the error (without upping the max errors for the FEC)?

BTW, I am using the script task to set a variable value to indicate successes or fails for those tasks where I can set the max errors to a high enough level (allow the error to occur, then let the fail/success precedent constraint pass control to the script task so that the variable can be set). This is only a partial solution.



I am new to SSIS, in fact to the MS world having been a code slinger for Java and Oracle. So far I have been very impressed with SSIS. Analogous structures that I expect to find in modern development environments have been within easy reach. This is my first serious challenge. Please help.

SCott

View 4 Replies View Related

Reporting Services Login Box Appears When Trying To Deploy In SSRS 2005

May 31, 2007

Hi All,

I installed SQL Server 2005 SP2 recently. After that when I try to
deploy a solution in SSRS 2005, I get a dialog box with title:
"Reporting Services Login". It has my server listed as the first row:
"http://localhost/reportserver" and then it has two text boxes asking
for Username and Password.

I checked my IIS settings and only Integrated Security is checked for
the Reports Server folder (and for the entire website). I tried to
change that to Allow Anonymous Access = Checked, but still the same
problem.

Any ideas?

Thanks! GB

View 81 Replies View Related

Login Fails For FQDN But Works For IP Address

Apr 15, 2008

When attempting to connect to Reporting Services (SQL2005) with FQDN, the logon prompt fails after 3 attempts:
http://sqlReportServer.mydomain.net/ReportsManager/Pages/Folder.aspx

If use the IP, it prompts for credentials and works:
http://192.168.0.23/ReportsManager/Pages/Folder.aspx




I have checked the SQL instance name and seems good. RDP by FQDN works fine, etc. Any hints?
CW
--

View 1 Replies View Related

Login Fails For Network SQL Server But Works For Localhost

Jul 18, 2005

I have an ASP.NET webform:This connection works:   "Server=localhost;uid=sa;pwd=;database=pubs"but this connection DOES NOT work:  "Server=dnrsqlt1;uid=sa;pwd=;database=pubs"dnrsqlt1 is a sql server my network.Do I have to do something to users ASPNET or  IUSER_Machinename on the remote machine

View 6 Replies View Related

User Login Box Appears On Trying To Deploy SSRS 2005 Project To Report Manager

Dec 1, 2007



Hi
I have picked up the same problem that quite a few folks have identified.

I have created a SSRS Solution and have a report which I am trying to deploy to the Report Manager.
The project 'builds' locally but when I try to deploy it, a User Login Box pops up.

Has any one been able to ascertain what causes the problem and how does one go about resolving the problem.
I am using Window Authentication on WIndows XP SP2 with SQL Server 2005 Developers Edition and Visual Studio 2005 Professional
I have not 'tinkered' with IIS,.

Any help would be greatly appreciated.
regards Steve

View 7 Replies View Related

I Can't Login To Sqlserver With A Username And A Password But Works With NT Integrated Security !!

Nov 21, 2006

hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !! and says

"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"

while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password

thanks in advance

View 3 Replies View Related

SQL Server2005 And Login Control

Aug 26, 2006

Dear !From Couple of days i waste my hours on it. but i fail to solve this problem.Can we use SQL server 2005 and Login Control of ASP.NET. when i try to use it gives me an error. An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   May be it works with SQL Express Edition as in learning videos. But i want to use it wit SQL server 2005. Very intersting thing i create the Mange City Page. in this page it works perfect. in this page city table takes a parameter from dropdownlist. perfectly working. but with login page it gives me error. 

View 1 Replies View Related

Migrate Login Control To SQL

Dec 18, 2007

Hi,
I was able to create an MSSQL database with the ASPNETDB.MDF file.  But how do I get the Login Control to point to the MSSQL rather than the App_DataASPNETDB.MDF file?
 

View 2 Replies View Related

Windows App Form Works: Datagrid Doesn't 'login Failed' ..tutors Out There?

Sep 11, 2005

Anyone live in seattle (meet on cap hill)? I have been stuck for weeks now and can't wait any longer wasting time - i will pay someone to set me up correctly quickly. I doubt this will be resolved online, but here goes... I need a datagrid to bring up simple database info (northwind) instead of showing the error 'login failed for mycomputeraspnet'. I am using windows authentication and my string is connectionstring = datasource=(local)\netsdk;initial catalog=Northwind;integrated security=sspi; persistent security=false;, I have seen online they say alter the authorization in the app virtual directory-- is that the C/inetpub/wwwroot or the web config of my project? I did so in the web config of my project, and also I added the impersonate=true to same already. I shared all the folders and made sure they are not read-only. I am flabbergasted.
Paul
XP pro 2004 sp 2
vis studio 2002 w updates
C# Asp web app project

View 2 Replies View Related

SQL Server Express For Login Control

Aug 11, 2006

I have built a page with the login control using the default sql server express database that is integrated into the application. I have got it working on my development machine and want to post it on the web with a web hosting company. I did not know if they had to have sql server express installed on that machine for my database to work properly or will it work with sql server 2005 installed. Most web hosting companies that I have called say they only support sql server 2005 and not sql server express. I was unsure if the login would work or not. Please help with this issue. I am new at ASP.net and really enjoy it. However, I want to ensure that my site will work on the web as it does on my machine.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved