January 18, 2009 at 10:59 am
I'm running SQL Server 2005 Developer on a laptop and I'm trying to connect Crystal Reports 2008 to it. When I try (either using Native Client or OLE DB) I get the '18452' message which says the ID I'm using (SHughes) isn't associated with a trusted SQL Server connection.
Needless to say, the ID is set up in SQL Server as sysadmin and it works fine in SSMS and in SSIS.
This should be a no-brainer, but apparently I'm not seeing the woods for the trees.
Suggestions appreciated.
January 19, 2009 at 9:40 am
Just a couple of thoughts...
1.) What protocols have you enabled in SQL Server?
2.) What network connection types are you allowing in SQL Server?
I have my SQL Server 2005 DE instance configured to accept shared memory and Named pipes and TCP/IP. What may make a difference is whether or not that Crystal Report will ever need to be run from any machine OTHER than your SQL Server. If that's the case, you may need a different version of your report that uses ODBC.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
January 20, 2009 at 3:18 am
I have everything enabled except VIA.
January 20, 2009 at 12:14 pm
I wish I could be more help, but I don't have Crystal Reports to test with. Any chance that your ID in SQL Server doesn't have CONNECT to SQL Server granted to it?
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
January 20, 2009 at 1:57 pm
Everything is set up properly. I rebooted again this AM and evrything works fine. Connected poroperly 1-2-3.
Another in a series of "Software Mysteries"
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply