Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act! 2011 and SQL Server connection problems

New Member
Posts: 7
Country: USA

Re: Act! 2011 and SQL Server connection problems

Unfortunately I didn't have any luck with that either. I was unable to create a database and I still couldn't get the SQL (ACT7) server to start without immediately stopping.
New Member
Posts: 7
Country: USA

Re: Act! 2011 and SQL Server connection problems

Mike,

 

I was looking further into what you had written previously and I saw a zillion errors for MSSQL$ACT7 under the windows event viewer under Applications. 

 

Here's what it says:

 

sql trace was stopped due to server shutdown.  trace id = '1'

 

Details Tab:

 

- <System>
  <Provider Name="MSSQL$ACT7" />
  <EventID Qualifiers="16384">19032</EventID>
  <Level>4</Level>
  <Task>2</Task>
  <Keywords>0x80000000000000</Keywords>
  <TimeCreated SystemTime="2011-02-17T06:06:30.000000000Z" />
  <EventRecordID>33955</EventRecordID>
  <Channel>Application</Channel>
  <Computer>007-PC</Computer>
  <Security />
  </System>
- <EventData>
  <Data>1</Data>
  <Binary>584A00000A0000000C0000003000300037002D00500043005C0041004300540037000000070000006D00610073007400650072000000</Binary>
  </EventData>
  </Event>
 
 
 
Thanks for your help.
Platinum Elite Contributor
Posts: 14,607
Country: Australia

Re: Act! 2011 and SQL Server connection problems

Is the only EventID: 19032
If not can you post some of the others?
Also, the SQL log would be useful
New Member
Posts: 1
Country: USA

Re: Act! 2011 and SQL Server connection problems

Was there a resolution on this? Been having the same issue and went throught the steps noted, to no avail. 

Art