access problem while connecting sql 2k in win 2k3

when i am connecting the sql server in windows 2003 using the sql analyser t
he following error occurs
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server do
es not exist or access denied.
the authentication mode is mixed.
ICF is enabled.
aliasing used is TCP/ip
NetBios is also enabled
Message posted via http://www.droptable.comHi
Is port 1433 opened? You need a minimum of this when using SQL
authentication.
If you use Integrated, you need the 135, 136 and 139 open too.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"abhilash c via droptable.com" <forum@.droptable.com> wrote in message
news:5c7648275a5d424f9056a2250fce8d53@.SQ
droptable.com...
> when i am connecting the sql server in windows 2003 using the sql analyser
the following error occurs
> Server: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not

exist or access denied.
> the authentication mode is mixed.
> ICF is enabled.
> aliasing used is TCP/ip
> NetBios is also enabled
> --
> Message posted via http://www.droptable.com

access problem while connecting sql 2k in win 2k3

when i am connecting the sql server in windows 2003 using the sql analyser the following error occurs
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
the authentication mode is mixed.
ICF is enabled.
aliasing used is TCP/ip
NetBios is also enabled
Message posted via http://www.sqlmonster.com
Hi
Is port 1433 opened? You need a minimum of this when using SQL
authentication.
If you use Integrated, you need the 135, 136 and 139 open too.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"abhilash c via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:5c7648275a5d424f9056a2250fce8d53@.SQLMonster.c om...
> when i am connecting the sql server in windows 2003 using the sql analyser
the following error occurs
> Server: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
> the authentication mode is mixed.
> ICF is enabled.
> aliasing used is TCP/ip
> NetBios is also enabled
> --
> Message posted via http://www.sqlmonster.com

Access Global Variables in Body

Is this possible? I am trying to access the global variables via custom code.
However I get this msg when I use the following code.
Public Shared Function Hello() As String
Return Globals.UserID
End Function
ERROR :- There is an error on line 1 of custom code: [BC30469] Reference to
a non-shared member requires an object reference.
I need to get the global variables Execution time, Page Number within the
body to format the report appropriatly.
Thanks in advance to helpers !In order to access the Global (or parameter for that matter) you have to
fully qualify it in the code window.
There are two fixes to your problem.
1. drag a text box to the report area
2. past something like this into it:
=Globals!PageNumber & " of " & Globals!TotalPages
3. run the report.
--
OR (doing it by ref from the code)
--
if you need to ref them from the code, the you have to declare them first in
your code like so:
Function pn()
Dim pn as String
pn = Report.Globals!PageNumber
Return pn
End Function
Function tp()
Dim tp as String
tp = Report.Globals!TotalPages
Return tp
End Function
----
Once you have that in the code window, you can type:
=Code.pn()
or
=Code.tp()
--
to get the pagenumber or total page global respectfully
"d pak" wrote:
> Is this possible? I am trying to access the global variables via custom code.
> However I get this msg when I use the following code.
> Public Shared Function Hello() As String
> Return Globals.UserID
> End Function
> ERROR :- There is an error on line 1 of custom code: [BC30469] Reference to
> a non-shared member requires an object reference.
> I need to get the global variables Execution time, Page Number within the
> body to format the report appropriatly.
> Thanks in advance to helpers !

Access denied thru ole db but not DSN

I have an asp page that at one time worked.
Now I get the below error msg. It only happens on my asp
page. I can run through access or vb and it connects fine.
It also works fine through a dsn. I have looked everywhere
to no avail. it is sql 2k sp 3.
any help is mucho appreciated
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
/macro/conn_test.asp, line 20
code:
<%
dim lca, sql, region
set lca = server.createobject
("adodb.connection")
lca.connectionstring
= " Provider=SQLoLEDB;Server=231v9;UID=LCAP;
Pwd=fxtool;Datab
ase=LCAOPS"
lca.connectiontimeout = 30
lca.Open
lca.close
%>Have you checked permissions on the registry keys? You could use regmon
from sysinternals.com to see what keys it accesses and see if it gets any
access denied messages.
Or maybe it can't find (or doesn't have security to see) the actual OLE DB
driver?
Will a UDL on the IIS machine, using that same driver and connection info,
connect to the SQL Server?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||This connection that is failing is using named pipes. Try adding this to
the connect string,
Network Library = dbmssocn. this will force it to use tcp/ip.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I am having the same problem Kevin is.
when I try to connect to my SQL Server (it is on a separate box from my
development workstation) through a simple windows application it works fine.
When I use the exact same code in an .aspx file, I get SQL Server does not
exist or access is denied.
I tried adding Network Library=dbmssocn, but when I did, even the windows
app stopped working.
Any suggetions would be appretiated.
thank you
Kirk Graves
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:fQ93b$d5DHA.2768@.cpmsftngxa07.phx.gbl...
> This connection that is failing is using named pipes. Try adding this to
> the connect string,
> Network Library = dbmssocn. this will force it to use tcp/ip.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>