Can connect to db directly, but website cannot

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Can connect to db directly, but website cannot

Author

Topic

hadoob024
Starting Member

5 Posts

Posted - 2010-10-06 : 12:27:28

I'm trying to figure out where my problem is. Just installed SQL Server 2008 R2 and loaded up my db. I can access the db just fine when going through SQL Server Management Studio, however, when I try to run my website it seems like it's just not connecting to the db. Does the SQL Server Agent service need to be running for this to occur? SQL Server (SQLEXPRESS) is running and so is SQL Server Browser, however, SQL Server Agent service does not want to run. When I start it, it says that it started and then stopped. I just don't know if this is the cause of my problem.

Here're the contents of my SQLAGENT.out log file:
2010-10-06 12:24:52 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2010-10-06 12:24:52 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2010-10-06 12:24:52 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2010-10-06 12:24:52 - ! [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysalerts', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion)
2010-10-06 12:24:52 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2010-10-06 12:24:52 - ! [000] Error creating a new session
2010-10-06 12:24:53 - ? [098] SQLServerAgent terminated (normally)

Any thoughts? Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-06 : 13:19:43

I thought you don't get the Agent with Express?

The Agent is not why you are encountering issues with your website.

Please post the error from the website.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hadoob024
Starting Member

5 Posts

Posted - 2010-10-06 : 15:08:58

Thanks. I actually just came across that myself.

Well, the good news is that I think this is an issue with the IDE I'm using. SQL Server seems to be working fine. Here's my connection info:

'dbconfig' =>
array (
'db_host_name' => 'localhost',
'db_host_instance' => 'LAPTOP\SQLEXPRESS',
'db_user_name' => 'sa',
'db_password' => '123456789qwerty',
'db_name' => 'insight',
'db_type' => 'mssql',
),
'dbconfigoption' =>
array (
'persistent' => false,
'autofree' => false,
'debug' => 0,
'seqname_format' => '%s_seq',
'portability' => 0,
'ssl' => false,
'collation' => 'utf8_general_ci',
),

The error message I get is:

Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\insight\include\database\MssqlManager.php on line 137 Fatal error: Call to undefined function mssql_connect() in C:\inetpub\wwwroot\insight\include\database\MssqlManager.php on line 137

Will start troubleshooting this from the other end instead of wondering what's wrong with SQL Server.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-06 : 15:14:17

see if this thread helps

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151081

hadoob024
Starting Member

5 Posts

Posted - 2010-10-06 : 15:54:18

Nice! Quick follow-up. I found ntwdblib.dll in my IDE's "Program Files" directory. Is this the directory that needs to be added to the PATH variable? Or do I need to copy this file to another location and THEN add it to the PATH variable?

Also, how do you know if ntwdblib is installed?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-06 : 17:11:46

Path it either way I imagine...

can register the dll yourself. even if it's already registered, it won't hurt anything

hadoob024
Starting Member

5 Posts

Posted - 2010-10-06 : 18:21:49

Dude! You're a genius! It worked. Up and running now....

Now if I could only get back today's lost time trying to figure this out.... :)

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-06 : 21:00:21