How to create SQL database for Citrix?

if you have sql running on another machine, make sure you enable tcp/ip (in properties put 1433 under the all ip addresses section) in the sql server configuration manager and allow tcp:1433 through the firewall. Then use ssms to make a login with the right permissions.

Thanks for responding!  Sounds like you may be able to help me.  :)

I have firewalls disabled on both server so 1433 should be fine.
I am logged into both servers as domain\administrator.

I installed SQL server 2012 and input domain\administrator to run as the service account.
So SQL server and SQL browser services are running and as domain\administrator.

I made sure that TCP/IP and Named pipes are enabled in sql confguration manager.

I even added the computer account of the Citrix server to the local administrators group on SQL server.

I checked security log and saw a bad login attempt for my citrix server name, but can not even get that anymore.

I also tried running the database script that is generated optionally, but bombs out for me.
I attached it in case it means something...I would rather create the database from citrix server (easier I thought).
Script-For-Database-SQL2012-MSSQ.sql

Thanks again!
I only used domain\administrator as SQL service accounts because I re-installed SQL thinking if I matched everything up to this login, maybe I could create the database from Citrix install (remotely).

Thanks for the useful warnings I would definitely follow in production, this is a lab test environment. :)

I am using mixed mode authentication.

Still not sure what to do, so that this Citix server can create the database remotely.

I will re-install and report back with exact configuration.

Thanks for hanging in there.  :)

Ok, I've reinstalled SQL2012 and attached configuration pics (everything else default).
I am using domain\administrator as an administrator user for now.  Just trying to get some functional test going...

I have the two servers XD7a and SQL2012, both logged in to Windows server as domain\administrator, firewalls disabled (GPO).

What are the next steps to allow XD7a server to create a database on SQL2012?
Enable SQL Browser, enable Named pipes, add XD7a computer account to local administrator group?

This article explains Citrix to database permissions, look at administrator section.  I dont know why mine is not working with domain\administrator.
http://support.citrix.com/article/CTX127998
sql1.jpg
sql2.jpg
sql3.jpg
sql4.jpg
citrix1.jpg

Ok, I finally got the Database script to work, and database created manually.
But still get an error trying to connect to it!
Since the database is created already, it should be a different permission problem at this point?

I can ping the server, and use a troubelshooting method with telnet to verify that port 1433 is open.  I also enabled SQL Browser service and Named Pipes.  

What else could I be missing?

Have you tried using the SA account and password instead of a domain account?

Wow, the Citrix Studio prompts for server\instance name but it works with the short name.
I was able to connect to it from a different server using ssms and also able to create an ODBC connection.

I think it must be the Citrix studio part or in general.
I think I am moving along now.

Thanks for all your help!!