I have a SQL Server 2005 Express db on my local machine for testing and I'm
using Dreamweaver 8 to connect to it. No problem. However.. when I try out
a page on localhost through a browser, I get this message:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open datab
ase
"Linker_app" requested by the login. The login failed.
/linkerapp/login.asp, line 24
That would usually be a permissions issue, but I found the database and
allowed the Internet Guest Account to access it . .but the message is still
there.
Can someone tell me what I'm doing wrong?
Many thanks!
NancyHere are some Express links that might come in handy. I would check to
ensure it allows remote connections and that the db is open.
http://msdn.microsoft.com/library/d...r />
rview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn.microsoft.com/sql/defau... />
erinst.asp
User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/a.../05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn.microsoft.com/sql/expre...qlexcustapp.asp
Embedding Express in Apps
http://blogs.msdn.com/rogerwolterbl.../13/575974.aspx
Backing up Express
Andrew J. Kelly SQL MVP
"Nancy" <nancy@.webwish.com> wrote in message
news:eYRSl$oZHHA.3928@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server 2005 Express db on my local machine for testing and I'm
>using Dreamweaver 8 to connect to it. No problem. However.. when I try
>out a page on localhost through a browser, I get this message:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open dat
abase
> "Linker_app" requested by the login. The login failed.
> /linkerapp/login.asp, line 24
>
> That would usually be a permissions issue, but I found the database and
> allowed the Internet Guest Account to access it . .but the message is
> still there.
> Can someone tell me what I'm doing wrong?
> Many thanks!
> Nancy
>|||got it .. thank you for the excellent links .. I have bookmarked many of
them.
Nancy
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ujFpbbsZHHA.4368@.TK2MSFTNGP06.phx.gbl...
> Here are some Express links that might come in handy. I would check to
> ensure it allows remote connections and that the db is open.
> http://msdn.microsoft.com/library/d.../>
verview.asp
> Express Overview
> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
> with MSDE
> http://msdn.microsoft.com/sql/defau...>
userinst.asp
> User Instances
> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
> for Remote Access
> https://blogs.msdn.com/sqlexpress/a.../05/415084.aspx
> Configuring Remote Access
> http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
> remote access
> http://msdn.microsoft.com/sql/expre...qlexcustapp.asp
> Embedding Express in Apps
> http://blogs.msdn.com/rogerwolterbl.../13/575974.aspx
> Backing up Express
> --
> Andrew J. Kelly SQL MVP
> "Nancy" <nancy@.webwish.com> wrote in message
> news:eYRSl$oZHHA.3928@.TK2MSFTNGP03.phx.gbl...
>
Tuesday, March 20, 2012
Permissions issue?
Labels:
connect,
database,
dreamweaver,
express,
local,
machine,
microsoft,
mysql,
oracle,
permissions,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment