|
|
You're in the
sql server msde
group:Unable to Connect to MSDE
sql server msde:
edition of SQL. The hosting service I am using has MSDE 2000 installed on my Windows 2000 Server. I have installed the application DBAMGR to provide a tool for working with the database. Using DBAMGR, I was able to connect to the SQL server and create a new database (Database1) and table (Table2). My problem occurs when I try to access the database from my WebService connection code. I get SQL database does not exist or access is denied. Now, my new database and table appear to be controlled by dbo in sql. Any suggestions? Private con As New SqlConnection("Data Source=localhost;trusted_connection=true;Initial Catalog=Database1") Dim stringSQL As String = "Select SectionID,ID,ParentID,ChildIndexList,Name,DateCreated,ControlledBy,AuthorizedToView,data,image,document,spreadsheet,IsEncrypted from " & DBTable (DBTable is a passed in string = "Table2" Dim MyCommand As New SqlCommand(stringSQL, con)
I have checked out the reference and found one area that may be affecting me,
"The Windows-level security that you are using to connect is different from what you expect. For example, Microsoft Internet Information Services (IIS) uses IUSR_computername". When my web service attempts to connect: Private con As New SqlConnection("Data Source=localhost;trusted_connection=true;Initial Catalog=Database1") Could I be running into some sql login missmatch on users. I thought using "trusted_connection" caused sql to ignore user issues? Fred Herring [quoted text, click to view] "Andrea Montanari" wrote:
> hi Fred, > Fred Herring wrote: > >... > > My > > problem occurs when I try to access the database from my WebService > > connection code. I get SQL database does not exist or access is > > denied. > > Now, my new database and table appear to be controlled by dbo in sql. > > the exception ou are reported with is a generic exception raised by MDAC > when connection troubles are found... please have a look at > http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql > -- > Andrea Montanari (Microsoft MVP - SQL Server) > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0 > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual > interface) > --------- remove DMO to reply > >
It seems that the MSDE uses Windows security (by defalult). Yu must give
either ASPNET account, or IUser_MachineName account permmision to the database/tables/Views/SPs on the MSDE, depending what account is configured to use the web services. [quoted text, click to view] "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message SectionID,ID,ParentID,ChildIndexList,Name,DateCreated,ControlledBy,Authorizenews:43B3D18E-1908-48D7-85D6-ECFDE454BAEE@microsoft.com... > I am new to msde for I have done all my develpment work with the Developer > edition of SQL. The hosting service I am using has MSDE 2000 installed on my > Windows 2000 Server. I have installed the application DBAMGR to provide a > tool for working with the database. Using DBAMGR, I was able to connect to > the SQL server and create a new database (Database1) and table (Table2). My > problem occurs when I try to access the database from my WebService > connection code. I get SQL database does not exist or access is denied. > Now, my new database and table appear to be controlled by dbo in sql. Any > suggestions? > > Private con As New SqlConnection("Data > Source=localhost;trusted_connection=true;Initial Catalog=Database1") > > Dim stringSQL As String = "Select > dToView,data,image,document,spreadsheet,IsEncrypted from " & DBTable [quoted text, click to view] > > (DBTable is a passed in string = "Table2" > > Dim MyCommand As New SqlCommand(stringSQL, con) > > > >
I am still struggling with msde logon issues. I need to connect to msde from
my iis web service. Now, when my web service thru iis attempts to contact MSDE to logon, who does sql see as the requesting entity. My windows login/password or something else. Thanks, Fred Herring [quoted text, click to view] "Norman Yuan" wrote:
> It seems that the MSDE uses Windows security (by defalult). Yu must give > either ASPNET account, or IUser_MachineName account permmision to the > database/tables/Views/SPs on the MSDE, depending what account is configured > to use the web services. > > "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message > news:43B3D18E-1908-48D7-85D6-ECFDE454BAEE@microsoft.com... > > I am new to msde for I have done all my develpment work with the Developer > > edition of SQL. The hosting service I am using has MSDE 2000 installed on > my > > Windows 2000 Server. I have installed the application DBAMGR to provide a > > tool for working with the database. Using DBAMGR, I was able to connect > to > > the SQL server and create a new database (Database1) and table (Table2). > My > > problem occurs when I try to access the database from my WebService > > connection code. I get SQL database does not exist or access is denied. > > Now, my new database and table appear to be controlled by dbo in sql. Any > > suggestions? > > > > Private con As New SqlConnection("Data > > Source=localhost;trusted_connection=true;Initial Catalog=Database1") > > > > Dim stringSQL As String = "Select > > > SectionID,ID,ParentID,ChildIndexList,Name,DateCreated,ControlledBy,Authorize > dToView,data,image,document,spreadsheet,IsEncrypted from " & DBTable > > > > (DBTable is a passed in string = "Table2" > > > > Dim MyCommand As New SqlCommand(stringSQL, con) > > > > > > > > > >
By default, it is ASPNET (annonumous access, no impersonation). You need to
give this account access to your database in MSDE. You need to study a bit more on ASP.NET security to know exactly which user account is using the ASP.NET/Web services app. It could be ASPNET, IUser_MahcineName, or a domain account, depending on ASP.NET/Web services project configuration (usually, look inot app.webconfig file). [quoted text, click to view] "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message news:33D2E46E-B789-46A0-9386-E46DB06F776D@microsoft.com... > I am still struggling with msde logon issues. I need to connect to msde from > my iis web service. Now, when my web service thru iis attempts to contact > MSDE to logon, who does sql see as the requesting entity. My windows > login/password or something else. > > Thanks, > Fred Herring > > "Norman Yuan" wrote: > > > It seems that the MSDE uses Windows security (by defalult). Yu must give > > either ASPNET account, or IUser_MachineName account permmision to the > > database/tables/Views/SPs on the MSDE, depending what account is configured > > to use the web services. > > > > "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message > > news:43B3D18E-1908-48D7-85D6-ECFDE454BAEE@microsoft.com... > > > I am new to msde for I have done all my develpment work with the Developer > > > edition of SQL. The hosting service I am using has MSDE 2000 installed on > > my > > > Windows 2000 Server. I have installed the application DBAMGR to provide a > > > tool for working with the database. Using DBAMGR, I was able to connect > > to > > > the SQL server and create a new database (Database1) and table (Table2). > > My > > > problem occurs when I try to access the database from my WebService > > > connection code. I get SQL database does not exist or access is denied. > > > Now, my new database and table appear to be controlled by dbo in sql. Any > > > suggestions? > > > > > > Private con As New SqlConnection("Data > > > Source=localhost;trusted_connection=true;Initial Catalog=Database1") > > > > > > Dim stringSQL As String = "Select > > > > > SectionID,ID,ParentID,ChildIndexList,Name,DateCreated,ControlledBy,Authorize > > dToView,data,image,document,spreadsheet,IsEncrypted from " & DBTable > > > > > > (DBTable is a passed in string = "Table2" > > > > > > Dim MyCommand As New SqlCommand(stringSQL, con) > > > > > > > > > > > > > > > > > >
hi Fred,
[quoted text, click to view] Fred Herring wrote: >... > My > problem occurs when I try to access the database from my WebService > connection code. I get SQL database does not exist or access is > denied. > Now, my new database and table appear to be controlled by dbo in sql. the exception ou are reported with is a generic exception raised by MDAC when connection troubles are found... please have a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
I am still having problems connecting to the msde datatase with my web
service on my hosting computer. My database is called Database1 and has one table called Table2. I tried creating login accounts in DBAMGR for IUSER_ServerNafme, and ASPNET. I gave full database rights. No luck. Private con As New SqlConnection("Data Source=localhost;trusted_connection = true ; Initial Catalog=Database1") Private a As Integer <WebMethod(Description:="Requesting Dataset")> Public Function GetData(ByVal DBTable As String) As Byte() Dim MyData(100000) As Class1 Dim i As Integer = 0 Dim stringSQL As String = "Select SectionID,ID,ParentID,ChildIndexList,Name DateCreated,ControlledBy,AuthorizedToView,data,image,document,spreadsheet,IsEncrypted from " & "Table2" I get the error, "Database does not exist or access denied. " My web service config file has the following code relating to sql server: <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" cookieless="false" timeout="20" /> <globalization requestEncoding="utf-8" responseEncoding="utf-8" /> Is this telling me that my web service is using sa as its login? Still confused, Fred Herring [quoted text, click to view] "Norman Yuan" wrote:
> By default, it is ASPNET (annonumous access, no impersonation). You need to > give this account access to your database in MSDE. You need to study a bit > more on ASP.NET security to know exactly which user account is using the > ASP.NET/Web services app. It could be ASPNET, IUser_MahcineName, or a domain > account, depending on ASP.NET/Web services project configuration (usually, > look inot app.webconfig file). > > "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message > news:33D2E46E-B789-46A0-9386-E46DB06F776D@microsoft.com... > > I am still struggling with msde logon issues. I need to connect to msde > from > > my iis web service. Now, when my web service thru iis attempts to contact > > MSDE to logon, who does sql see as the requesting entity. My windows > > login/password or something else. > > > > Thanks, > > Fred Herring > > > > "Norman Yuan" wrote: > > > > > It seems that the MSDE uses Windows security (by defalult). Yu must give > > > either ASPNET account, or IUser_MachineName account permmision to the > > > database/tables/Views/SPs on the MSDE, depending what account is > configured > > > to use the web services. > > > > > > "Fred Herring" <FredHerring@discussions.microsoft.com> wrote in message > > > news:43B3D18E-1908-48D7-85D6-ECFDE454BAEE@microsoft.com... > > > > I am new to msde for I have done all my develpment work with the > Developer > > > > edition of SQL. The hosting service I am using has MSDE 2000 > installed on > > > my > > > > Windows 2000 Server. I have installed the application DBAMGR to > provide a > > > > tool for working with the database. Using DBAMGR, I was able to > connect > > > to > > > > the SQL server and create a new database (Database1) and table > (Table2). > > > My > > > > problem occurs when I try to access the database from my WebService > > > > connection code. I get SQL database does not exist or access is > denied. > > > > Now, my new database and table appear to be controlled by dbo in sql. > Any > > > > suggestions? > > > > > > > > Private con As New SqlConnection("Data > > > > Source=localhost;trusted_connection=true;Initial Catalog=Database1") > > > > > > > > Dim stringSQL As String = "Select > > > > > > > > SectionID,ID,ParentID,ChildIndexList,Name,DateCreated,ControlledBy,Authorize > > > dToView,data,image,document,spreadsheet,IsEncrypted from " & DBTable > > > > > > > > (DBTable is a passed in string = "Table2" > > > > > > > > Dim MyCommand As New SqlCommand(stringSQL, con) > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |